General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
>>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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only