No. Transactions are not supported across DBCs.
>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,
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer