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