Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transaction seems to work but records disappear
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Transaction seems to work but records disappear
Miscellaneous
Thread ID:
00353297
Message ID:
00353297
Views:
48
We have a situation where adding records to a VFP table inside of a transaction appears to work. IOW, tableupdate() returns .t. Browse the table and the records are there. Yet after the end transaction the records are not there and there is no error message. Pack the table and it will start accepting records again. Of course, this happens intermittently and to date, MS has been not very helpful. They focused on how to fix the data saying that the reason tableupdate returns true is the database is corrupted. It becomes a bit of a chicken & the egg situation. They are saying that you can rely on tableupdate to work properly if the database is not corrupted. This means that the converse is true. If the database is corrupted then tableupdate is unreliable. Unfortunately, in this particular situation there is no indication of corruption until an audit shows missing records. At this point, it becomes an issue of reliability. Other than constantly testing the validity of the database, I'm not really sure what the next step should be. Any comments would be appreciated.
Reply
Map
View

Click here to load this message in the networking platform