Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Transaction Problem
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement