Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Most strange corruption ever
Message
From
23/08/2002 08:57:07
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
22/08/2002 21:55:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00692378
Message ID:
00692857
Views:
32
>Hi Peter,
>
>I wrestled with these issues late last year, and by chance I came across Gareth's KB article which reported the 'problem' that if records were added to a corrupted file (header count error), no error was reported. It is now classified as a 'bug'.
>
>You might verify this in your situation, simply by corrupting one of the tables known to have the problem. I did this with a journal file which adds a record for every transaction event. With the table corrupted, the program apears to run normally, but no journals are added.
>
>The only workaround, I think, is to add the new record with only its primary key, make sure it is flushed to disk (not necessarily with flush) and read it back to update the rest of the data.

There was another workaround, which helped in those cases when
- user A creates a new record
- user B creates a new record
- user B saves
- user A saves and overwrites B's record
The workaround was to call Reccount() immediately after the tableupdate(), which somehow forced the header to be updated with the correct record count. May as well work in other cases.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform