DBF and CDX synchronization

[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.

[rdonnay]

Do you do a dbCommit() after your dbAppend()?

[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

[Victorio]

Hi Bobby,
I can try it, maybe this help.
Thank you very much !