FiveTech Software tech support forums

There are quite a few situations where providing FastEdit (inline edit) is very appropriate. Most of such situations also require auto appending new blank rows inline. That is, when the users presses down arrow key or completes edit of last row, a new blank row should be automatically created ...

... 5000 records) initially and display the browse on the screen within less than a second and then read remaining records in parts or full and keep appending these records to the main rowset as and when time permits. When to read and the size of the chunks depends on the programmer's choice that ...

... appended row, any navigation automatically calls Save(). Example: oRs:Salary := 20000oRs:Save()//oroRs:Skip()  // saves and skips  Appending Rows: oRs:Append() or oRs:AddNew() Creates a new blank record. We can edit the fields in the usual way and call Save() or navigate to append ...

... two ago we discovered that the ADORDD was doing a commit after each record during APPENDs. This was taking 11 hours to append 26 thousand records. Appending the same file using DBFs took 1 second. So, buffering before writing to disk provides a tremendous increase in speed. One would expect this ...

... at last. I have been able to import a large number of records from a DBF into a SQL table in an ACCESS database using the APPEND FROM command. Appending 26,191 records with 31 fields from a DBF into an ACCESS table: 18 minutes. Appending the same records from a DBF into a DBF: 1 second Hmm, ...

... at last. I have been able to import a large number of records from a DBF into a SQL table in an ACCESS database using the APPEND FROM command. Appending 26,191 records with 31 fields from a DBF into an ACCESS table: 18 minutes. Appending the same records from a DBF into a DBF: 1 second Hmm, ...

... were due to another buildx.bat file that was in the path which was not linking in all three of the LIBs needed for the ADORDD. My bad. I tried appending from a dbf to a SQL table (in an ACCESS) and it worked until it crashed at record 548. I am including the error log below. I'm at a loss at ...

Antonio, To debug OrdSetFocus(), I need the fix for dbfilter() please, to trace the problem. It my be related when appending of replacing records, the filter is cleared?. I don´t know if it happened before. About ArrayTranspose(), its aviable here: https://bitbucket.org/fivetech/fiveweb/src/f1d5073aae35f6945424f83ccb1369c2d9b0205b/source/function/harbour.prg?at=master ...

... FROM CUSTOMER WHERE CODIGO=#10# ORDER BY CODIGO But in ADO should be: SELECT CUSTOMER.* FROM CUSTOMER WHERE CODIGO=10 ORDER BY CODIGO Also, when appending a dbf with 30 fields, I get: Error description: (DOS Error -2147352567) WINOLE/1006 Record is too large. (0x80040E21): Microsoft JET Database ...

... ADO_GETUNLOCK( 2776 ) Also, Append does not work fine. The first time I append a record: http://i57.tinypic.com/nyg3uw.jpg When appending next records, it seems ok.

Antonio, For appending and browsing, Recordset should be opened at STATIC FUNCTION ADO_OPEN( nWA, aOpenInfo ) as shown:   oRecordSet:CursorLocation := adUseClient //its slower but has avntages such always bookmaks   oRecordSet:LockType ...

... days, it was said that if you move the record pointer it forced the workarea buffers to be flushed to disk. In cases where I am in a Do While loop appending or editing many records, I issued a dbSkip(0) after each change. DbSkip(0) technically moves the record pointer back to itself, theoretically ...

Seems to be a problem with logging.

I only get the following in the file:

06/12/14 07:26:15: 35

It would appear each submission writes the same line over rather than advancing / appending a line.

Tim

... this codeblock is called with the object as pararmeter, for saving data to the individual fields, instead of using the internal logic. Locking / appending and unlocking is taken care of by the class and the codeblock should contain logic to assign values to individual fields only. This codeblock ...

... it with TDolphin also without any extra coding. This works the same way as with arrays, dbfs, recordsets, etc. If you like to show a blank row for appending a row, it is easy with arrays and recordsets ( using AddNew() method when opened in batchoptimistic locking mode ). Can also do with dbfs ...