Information générale
Catégorie:
Codage, syntaxe et commandes
Colin,
Not having yet had the need for transactions, I can only go by things I read here and in the docs.
This response of yours seems to contradict your earlier one saying that a TableRevert() is what's needed.
I certainly would have expected things to operate as per your example here, precluding the need for a TableRevert(). What do you figure is the explanation?
Cheers,
Jim N
>No, it reverts the data as well. Try the following as an example:
>
>USE tablename
>set optimistic table buffering
>BEGIN TRANS
>modify a few records
>TABLEUPDATE(1) &&Updates all records
>ROLLBACK
>
>The records will be reverted back to original values and the transaction is ended.
>
>>Thanks for youy responses.
>>
>>But I'm confused. What is the purpose of Rollback if it doesn't revert that data?? Is only to prevent writing to disk??
>>
>>We need the transaction because it is an all or nothing situation.
>>
>>Sandy
Précédent
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