Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Data Loss
Message
From
02/04/2003 13:04:45
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
 
 
To
02/04/2003 11:51:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00772957
Message ID:
00773094
Views:
15
Hi Doug,

>
>Are you inserted records into the account balance table or just updating values? If the former, then this could be caused by table corruption, although you've used SDT to repair it so it shouldn't be an ongoing problem (unless corruption is recurring). If the latter, then check to ensure TABLEUPDATE() is returning .T. (I'm sure you're doing that, but JIC) and that you're not double-buffering the table (that is, the view is buffered *and* the table is buffered, so TABLEUPDATE() of the view is writing to the table's buffer, but you're not using TABLEUPDATE() on the table, so the changes are being discarded).
>

We are just updating fields on an existing record in the account balance table. We are using our framework's (ProMatrix) save routine to commit the data. As you might expect, it is a robust routine that will return various error codes for failures. It indicates success. I don't think we have any double-buffering going on, but I will double check we aren't manipulating the underlying table directly. As I said before, we close the view/table and re-open it, at which time it has the balance we expect. According to my logic, this indicates that at least VFP considers the data committed. Is that the conclusion you would make?

Thanks for the suggestions.
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform