General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Transaction seems to work but records disappear
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only