FiveTech Software tech support forums

... Hello friends, Here you see the source code how the mod harbour web APP sends the data with AJAX and how on the server a program gets the data and appends to a DBF file. We delete the local storage if we get back success from the server. If there raises a problem, the data remains stored in the ...

Rick Lipkin wrote:I will say that I find dbCommitt() very slow when you are adding many records at one time with a dbCommitt between appends.

Of course. One COMMIT at the end is enough.

... or in dbfcdx goto recno().... I will say that I find dbCommitt() very slow when you are adding many records at one time with a dbCommitt between appends. Rick Lipkin

Hello friends, Here you see the source code how the mod harbour web APP sends the data with AJAX and how on the server a program gets the data and appends to a DBF file. We delete the local storage if we get back success from the server. If there raises a problem, the data remains stored in the ...

... - If the dbf does not exist, dbf is created - Opens the dbf and chceks for the keys - If the keys exist, updates the value in the dbf - Otherwise appends a new entry with the values. EditIniDBF( cDbf ) - If the dbf does not exist and user wants to create, then the dbf is created - User can edit ...

... file 100 times. So I will build a small test program. I started with this test. The first button opens the database 2000 times. The second switch appends a data record in each work area. https://mybergland.com/fwforum/dbfspeed.gif

... it before getting into the next discussion. If you open the recordset with adLockBatchOtpimistic mode, all changes (modifications, deletions and appends) are written only to the Recordset in our PC's MEMORY ONLY but NOT written to the physical database. To finally save all the changes at once ...

... is on a single field. Now the order is restored even on multi-field sort asc/desc. * NEW: FWMariaRowset BATCHMODE In the batch mode, all edits, appends and deletes are retained in the memory only and nothing is written to the database, till all the changes are written in one call to SaveBatch() ...

... - Fix: oDbf:Blank(), assign values and calling oDbf:Save() is not working when eof is .t. Fixed now. - Fix: oDbf:Append() without parameters appends blank. But oDbf:Load() needs to be called for assigning values and saving. Now oDbf:Append() calls Load() also. - New method Browse( [cTitle], ...

... ID assigned ( ie. Workorder/Invoice, customer number, accounting, etc ). Since I have classes for each process like work orders, my Add() method appends a record, fills the buffers with blanks, then goes to the counter dbf, increments the proper number, saves the value back to the record, and ...

... ID assigned ( ie. Workorder/Invoice, customer number, accounting, etc ). Since I have classes for each process like work orders, my Add() method appends a record, fills the buffers with blanks, then goes to the counter dbf, increments the proper number, saves the value back to the record, and ...

... eg: dbf exists is already open, etc. In such cases oDbf:Used() returns .f. - Improved interface with DataRow: When Datarow object saves changes or appends new record, the changes automatically made directly by RDD like fields "+", "=" and triggers are immediately communicated ...

At present FW_ArrayToDbf(...) only appends records. For this reason, you need to Zap the dbf. In FWH 19.01, we added a new 4th parameter lOverWrite. If this parameter is set to .T., it overwrites the existing data from the current record. ...

Yes, that is the expected behaviour.

I advised you to use
oRs:bEdit := <yourfunc>
and
then
oRs:Edit( .t. )

Please stick to this approach only for edits/appends.

Are you using appendblank() for inline appends in XBrowse ?