>>>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 ?
>
A remote views is a remote cursor, but a remote cursor can not to be it.

Remote cursor is every temporary cursor not build with:

CREATE CURSOR
or
SELECT INTO CURSOR

Examples:
RV,SPT,VFP8's CA ...


VFP don't manage backend transaction.
You have to use SQLROLLBACK/SQLCOMMIT
or to use ORACLE's transaction commands.

>Thanks again,