Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to find the corruption????
Message
From
10/10/2003 03:25:22
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00837254
Message ID:
00837280
Views:
35
Hi,
The table header is corrupted, i.e. the file size in the header does not equal the actual table size. i.e. probably has record fragment on end of file. Also the prg must use transaction tracking, as any appends from the prg will not be saved - Documented bug.

Quickest way to fix - Append blank record to end of file on site, use XRAY, can download from download section. Delete appended record, then reindex and pack. This overwrites the record fragment, then all is happy.

Answer to your next question is, The reason why it worked when u appended record to the file, is because u didn't have transaction tracking on.

Hope this helps.
Regards N Mc Donald
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform