Forget what I just said - getting late here.
In addition to what Jim said, try not "forcing" the TABLEUPDATE() with .T. as the second param.
>You need to modify the records "within" the transaction.
>
>
>>I tried to learn about ROLLBACK command. I expected that by issuing ROLLBACK command my table will be back to previous state (discard any changes and appended records) but I was failed. What could be wrong?
>>Here is my listing:
>>
>>=cursorsetprop('Buffering',5,'tran') && activate buffering
>>sele tran
>>appe blan && add 1st record
>>repl inv_no with 'test 1'
>>appe blan && add 2nd record
>>repl inv_no with 'test 2'
>>begin tran
>>=tableup(2,.t.,[tran]) && write changes
>>roll && cancel changes
>>brow && new records still exist
>>*tablere(.t.,'tran') && this is the only way?
- Jeff