Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Quickest Way to Check for Invalid Reccount in Table Head
Message
 
To
07/02/2002 09:11:21
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00616383
Message ID:
00616590
Views:
23
Usually table corruption is caused by the Network or Windows OS issues, but not by the VFP data engine.
Basocally to check the record number in the header you may do something like this:

lc=left(filetostr(tablefile),10)
?recc()=asc(substr(lc,8,1))*256^3+asc(substr(lc,7,1))*256^2+asc(substr(lc,6,1))*256+asc(substr(lc,5,1))

Best Wishes

>Sergey,
>I read the entire thread and do not like any of the solutions offered there. I am now much less confident in VFP than I have ever been. The primary task is saving data and it appears that there is an unfixed internal bug that prevents the product from doing the one thing it was designed for. What to do...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform