Search found 83 matches: appended

Return to advanced search

Re: DBF . Commit

... the R lock flavor and the normal lock flavor. With DBRLOCK() you must use DBRUNLOCK(). And furthermore, APPEND BLANK operation locks the newly appended record so there is no need of another lock.
by Enrico Maria Giordano
Sun Oct 22, 2023 5:18 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF . Commit
Replies: 39
Views: 2323

Re: "id" for PRIMARY KEY ?

Jimmy I create my own primary keys that way I control when a table is appended .. if you use auto increment an attacker could force an table append or "Inject" records into your tables and the database doesn't care .. the primary keys are generated ...
by nageswaragunupudi
Tue Jul 25, 2023 2:10 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: "id" for PRIMARY KEY ?
Replies: 9
Views: 479

Re: "id" for PRIMARY KEY ?

Jimmy I create my own primary keys that way I control when a table is appended .. if you use auto increment an attacker could force an table append or "Inject" records into your tables and the database doesn't care .. the primary keys are generated ...
by Rick Lipkin
Tue Jul 25, 2023 1:48 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: "id" for PRIMARY KEY ?
Replies: 9
Views: 479

Re: Clase Nativa MySql

... In case of existing records, the changes will be written to that record and in case of blank record, a new record will be appended to the rowset. You can also use oRec:Edit() or oQry:Edit() or oQry:Edit( .t. ) Please try.
by nageswaragunupudi
Wed Mar 09, 2022 5:49 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase Nativa MySql
Replies: 18
Views: 1848

Re: Number of Fields

... editable, to show the array. The user sees it and can fill in the values. When you save it, upon completion, the array elements are recorded in appended daily records for each student. Views and reports can then be created to see the data, and you can even build a routine to edit it when desirable. ...
by Silvio.Falconi
Fri Oct 15, 2021 6:38 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Number of Fields
Replies: 9
Views: 883

Re: Number of Fields

... editable, to show the array. The user sees it and can fill in the values. When you save it, upon completion, the array elements are recorded in appended daily records for each student. Views and reports can then be created to see the data, and you can even build a routine to edit it when desirable.
by TimStone
Wed Oct 13, 2021 5:31 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Number of Fields
Replies: 9
Views: 883

New FTDN September/Septiembre 2019 (FWH 19.09)

... as paramter. After execution record pointer is restored. - New method FieldDefault( ncFld, uDefaultValue ): The default value will be used in all appended records. - Now this class can be used to read a batch of records from a DBF or MYSQL table. These records can be edited in memory, appended ...
by Antonio Linares
Sun Oct 13, 2019 11:14 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN September/Septiembre 2019 (FWH 19.09)
Replies: 1
Views: 2898

New FTDN May/Mayo 2019 (FWH 19.05)

... aStruct can be empty or Structure or list of fields. The function returns an ADO recordset, not connected to any database, but can be edited, appended, deleted and navigated like any other recordset. At any time, array of data can be retrieved with aData := RsGetRows( oRs ) Source: \fwh\source\function\adofuncs.prg ...
by Antonio Linares
Mon Jun 03, 2019 12:54 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN May/Mayo 2019 (FWH 19.05)
Replies: 4
Views: 3159

Re: To James Bott - Error Using TData

... will use the same process on their computers ( with different data ). When user A goes to add a customer, the number is assigned to the new/blank appended record and the counter advanced. The next person ( could be a fraction of a second later ), gets the next number. With this being done thousands ...
by TimStone
Wed May 29, 2019 3:30 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: To James Bott - Error Using TData
Replies: 49
Views: 5116

Re: to Nages: test for tdatabase

... : Field Type "+" Autoincrement numeric field. DBFCDX automatically increments the value in this field every time a new record is appended. Uniqueness and chronological continuity are assured even in multi-user environments. This field is read-only and we can not write this field ...
by nageswaragunupudi
Sun May 12, 2019 4:05 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: to Nages: test for tdatabase
Replies: 37
Views: 5680

Re: Option for Xbrowse Softseek to verify input field ?

Just a thought, but why not use the browse with it's search enabled. Start typing the data, and if you see no match, program a right click on the mouse to pop up an Edit screen, with a new record appended, where you can type in the data.
by TimStone
Tue Apr 30, 2019 6:51 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Option for Xbrowse Softseek to verify input field ?
Replies: 3
Views: 876

Re: to Nages: test for tdatabase

... next serial number in chronological order when the new record is saved in a multi-user environment. This can be known only when the new record is appended. I remember very well that you refused all advices in this regard. Even at the risk of you blaming me also, I would reuest you once again re-consider ...
by Silvio.Falconi
Sat Apr 27, 2019 8:04 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: to Nages: test for tdatabase
Replies: 37
Views: 5680

Re: to Nages: test for tdatabase

... fills the buffers with blanks, then goes to the counter dbf, increments the proper number, saves the value back to the record, and saves it to the appended record. The interaction with the counters file takes a fraction of a second and that is never an issue in multi-user environments. Even the ...
by nageswaragunupudi
Sat Apr 27, 2019 6:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: to Nages: test for tdatabase
Replies: 37
Views: 5680

Re: to Nages: test for tdatabase

... fills the buffers with blanks, then goes to the counter dbf, increments the proper number, saves the value back to the record, and saves it to the appended record. The interaction with the counters file takes a fraction of a second and that is never an issue in multi-user environments. It is important ...
by TimStone
Sat Apr 27, 2019 5:30 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: to Nages: test for tdatabase
Replies: 37
Views: 5680

Re: to Nages: test for tdatabase

... next serial number in chronological order when the new record is saved in a multi-user environment. This can be known only when the new record is appended. I remember very well that you refused all advices in this regard. Even at the risk of you blaming me also, I would reuest you once again re-consider ...
by nageswaragunupudi
Sat Apr 27, 2019 1:33 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: to Nages: test for tdatabase
Replies: 37
Views: 5680
Next

Return to advanced search