Thanks Arnon,
I'll have a look at 'SAVEPOINT' in the Oracle Docs.
Paul
>If you put a single transaction (open and commit/rollback) then yes.
>But you can do that within your programs as well.
>
>If you want to increase your rollback granularity you'd probably be better off with setting SAVEPOINTs i.e.
>SAVEPOINT TABLEA
>INSERT INTO TABLEA...
>SAVEPOINT TABLEB
>INSERT INTO TABLEB
>
>ROLLBACK TO SAVEPOINT TABLEA //will rollback the 2 inserts
>ROLLBACK TO SAVEPOINT TABLEB //will rollback only the second insert
>I havn't tried that in VFP - but it works in ADO and should work with SQLEXEC
>
>Arnon
>>Hi Larry,
>>
>>Would putting the sql statements in an Oracle stored procedure restrict the rollback to the one table?
>>
>>Paul
>>
Previous
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