DBF and CDX synchronization

Xbase++ 2.0 Build 554 or later
Post Reply
Message
Author
Victorio
Posts: 620
Joined: Sun Jan 18, 2015 11:43 am
Location: Slovakia

DBF and CDX synchronization

#1 Post 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.

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: DBF and CDX synchronization

#2 Post by rdonnay »

Do you do a dbCommit() after your dbAppend()?
The eXpress train is coming - and it has more cars.

User avatar
sdenjupol148
Posts: 151
Joined: Thu Jan 28, 2010 10:27 am
Location: NYC

Re: DBF and CDX synchronization

#3 Post 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

Victorio
Posts: 620
Joined: Sun Jan 18, 2015 11:43 am
Location: Slovakia

Re: DBF and CDX synchronization

#4 Post by Victorio »

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

Post Reply