>Hello all
>
>Simple question :
>
>If i'm accessing mutilple tables from Oracle and if my inserts are within a transaction and if i want to roll back all the inserts do i need to rollback from each invididual tables are one rollback will revert all the data
>
>Eg
>
>...Orcle Connection..
>
>Begin Transcation
>
>do while not eof()
>
>sele a
> Insert ...
> a=tableupdate(.t.)
>
>sele b
> Insert ...
> b=tableupdate(.t.)
>
>if a and b
> end trans
>else
> rollback
>endif
>
>In this code will rollback revert both a and b or only b.
>
>Thanks

If a and b are DBC's tables or remote cursors then YES.
Of course the VFP transaction commands don't touch the status of the ORACLE' transaction.