>>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.

Thanks for the reply, What is they are Remote Views ? could you explain VFP transaction commands don't touch the status of the ORACLE' transaction ?

Thanks again,