Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transaction Problem
Message
De
31/03/1999 16:38:32
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Transaction Problem
Divers
Thread ID:
00204038
Message ID:
00204038
Vues:
45
I am having fits making a transaction work. Code is:
... update data in form ...
BEGIN TRANSACTION
SELECT parent
lSuccess=TABLEUPDATE(2,.f.,ALIAS(),aSaveErrors)
...

I checked CURVAL() immediately before the tableupdate and immediately after. The table was UPDATED. I thought that BEGIN TRANSACTION created an additional set of buffers, TABLEUPDATE committed changes to those buffers, and END TRANSACTION committed those changes to disk. Here I see changes committed directly to disk - before END TRANSACTION is executed..

The table in question was opened with Optimistic Row Buffering.

Any ideas on what could be happening here? I have looked at this
until I am numb.

Thanks for any insight.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform