Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Data Loss
Message
De
02/04/2003 13:04:45
Joel Leach
Memorial Business Systems, Inc.
Tennessie, États-Unis
 
 
À
02/04/2003 11:51:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00772957
Message ID:
00773094
Vues:
14
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform