>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.
Mark McCasland
Midlothian, TX USA