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
>