Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Serious Question about TableUpdate and Transactions
Message
De
16/10/2001 14:54:40
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Serious Question about TableUpdate and Transactions
Divers
Thread ID:
00569201
Message ID:
00569201
Vues:
49
I have had at least 2 customers where a transaction was saved inside of a
Begin Trans
select a table
lsucces=tableupdate(.t.,.t.)
if lsuccess
select another table
lsuccess=tableupdate(.t.,.t.)
endif

...
if lsuccess
end transaction
else
rollback
endif

This process updates 10 tables. However, with these 2 customers there are transactions that do not include anything saved after the third table is processed. I would have thought this is impossible but I have their data and it certainly happened. If a table is in tablebuffer mode and is updated with tableupdate(.t.,.t.) and multiple records need to be committed, but some of them do not get saved what does tableupdate return? This is not clear and I have not figured out how to set up a test.

Any help greatly appreciated.

Thanks!
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform