lucasdebeltran wrote:Antonio,
Does append blank and replace work?.
In my tests from last week once the aplication was closed, data were lost.
Antonio L., please wait to the announcment.
Thank you.
Lucas,
The problem is with transactions please check adorrd.prg and try inhibiting transactions or try issue dbcommit() and check if it is ok.
Replace Im trying it seems to be ok.
:AddNew() is disrupted not ok anymore! (append)
The reason is that in order to enable seek expression like we do normally I had to add one more field to the selects that is INDEXKEY.
ex:
INDEX ON field1+field2+field3 TO xfile
SET INDEX TO xfile
when select
SELECT *.xfile, (field1+field2+field3) AS INDEXKEY ORDER BY field1,field2,field3
if the cursor is adUseClient INDEXKEY gets indexed by ADO.
This enable you to seek in any part of the seek key.
DBSEEK( SPACE(LEN(field1))+"whatever")
.or.
DBSEEK("whatever")
Now because INDEXKEY does not really exists in the table when we call :addnew() we get error.
Im trying to solve it.
Its an ADO problem because with SQL INSERT works ok.
May be M Rao or Enrico can give us a hand?