Page 1 of 1

DBF and CDX synchronization

Posted: Sat Jul 21, 2018 8:11 am
by Victorio
Hi,
who know, why update time of CDX is different after append record ?
After reindex the time both files are same, but after some append/replace time of CDX is not updated.
Reindex I cannot use because file is shared.
I use standard DBESYS, not ODBC here.

Re: DBF and CDX synchronization

Posted: Mon Jul 23, 2018 2:03 pm
by rdonnay
Do you do a dbCommit() after your dbAppend()?

Re: DBF and CDX synchronization

Posted: Thu Aug 16, 2018 5:53 pm
by sdenjupol148
Hi Victorio,

Before I migrated to ADS, I had a similar problem when updating CDX's from two different threads.
Steffen told me I should used ordSetFocus(0) before appending.
Then when you set back your index order it should be synchronized.
I never tried it because at that point I had already migrated to ADS but it might help you.

Bobby

Re: DBF and CDX synchronization

Posted: Fri Aug 17, 2018 2:43 am
by Victorio
Hi Bobby,
I can try it, maybe this help.
Thank you very much !