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
>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement