>Mark.
>What happens if in the middle of a transaction Vfp appl gives an error and i can't issue Sqlrollback() and the connection is lost, or the client goes down ???
>In my opinion i think that Oracle knows that a transaction is not completed and should be rolled backed.
>In several tests i can't reproduce this situation.
>Some idea to do ???. thanks in advance

I have looked thru my Oracle docs and have experimented with VFP and my Oracle database here. I could not stop the commit from happening if the connection is terminated. The only thing I did not try was shutting off power to my computer after insertng some records. SET TRANSACTION USE ROLLBACK SEGMENT RBSNAME did not have any affect either.