Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I want Error 15 Back
Message
 
To
03/05/2002 13:42:49
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00652342
Message ID:
00652555
Views:
22
>Yes, but when this occurs in VFP and does not generate an error it leads to data corruption and/or missing records. I have a way to fix the problem in both FoxPro and VFP when I know it is present but VFP's not informing me by way of an error is the problem.

Actually, VFP (in either 6.0 or 7.0) doesn't utilize the value contained in the header to return the correct number of records through RECCOUNT(). The only realiable way to make sure the number of records match is to actually retrieve the value from the header via low-level file I/O and, then compare it to RECCOUNT().

There really isn't much of a problem if the number of records in the header is greater than actual. Simply adding a record, then deleting and packing will fix it. The real problem is if this number is too low. It must be properly adjusted. If it isn't and the file is PACKed, you'll lose records.

The positive side to this is at least now, you have a method of checking for the problem and making the correction yourself. If you had error 15 back, you wouldn't be able to open the table, and thus have no way to fix (outside of a third party product).
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform