Hi All,

After looking at the responses in Buffering vs Transaction thread, I have a question, I know I can test this and resolve by myself, but If any knows this, he would save me lot's of time:

There were said that for habing success with Transactions the tables must be in a database.

Q) Can I put into a transaction a tableupdate from a table of one database and another table for other database? should it work properly?

(modified from Jim's sample):

LOCAL llRollBack
llRollBack = .F.

BEGIN TRANSACTION

IF NOT TableUpdate(1,.F.,"Customer") && customer is in DATA\001.dbc
llRollBack = .T.
ENDIF

IF NOT llRollBack AND NOT TableUpdate(1,.F.,"Sales") && sales is in DATA\001\PT\pt.dbc
llRollBack = .T.
ENDIF

IF llRollBack
ROLLBACK
ELSE
END TRANSACTION
ENDIF

Thanks in advance,