>>I am adding a record to each of 3 tables and then updating them, wrapped in a transaction. For some reason, the records are not going in to one of the tables. I stepped through to see what was happening. After the TABLEUPDATE, the record in question is in the table. I can seek it, browse it, etc. and all looks fine. It's when I END TRANSACTION that the record disappears and the reccount drops back down. Apparently this file keeps getting corrupted, but why would that happen on an END TRANSACTION? Any suggestions?
>>
>>Thanks,
>>Elyse
>
>Do all of your TABLEUPDATEs() return .T.? And are you checking for error conditions?
>
>Bill
My code looks something like this:
IF !TABLEUPDATE(2,.f.,"Table1") OR !TABLEUPDATE(2,.f.,"Table2") OR ;
!TABLEUPDATE(2,.f.,"Table3")
llError=.t.
ENDIF
IF llError
ROLLBACK
ELSE
END TRANSACTION
ENDIF
The record is there after the TABLEUPDATE. It loses it after the END TRANSACTION.
Elyse
Elyse Pomerantz