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