>>I have sqlsetpror('transac',2) in an apllic for transaction no automatic. When I insert rows into the oracle table and end the appl with sqldisconnect() (w/o send sqlcommit), or quit Vfp the rows inserted there was not deleted from the table. teoretically Oracle issue an implicit backout transcation and those rows disappear from the table.
>>What's wrong. I appreciatte your help. thanks in advance
>
>In Oracle, when a user disconnects with un-committed changes still in the buffer, an auto-commit is issued by Oracle. What the Manual Transaction feature does is allow you to rollback all the changes for all the SQL commands you have issued since the last ROLLBACK or COMMIT. So, the only way to NOT save changes is to explicitly issue a ROLLBACK command.
>
>Conversely, if the Transaction is set to automatic, an implicit COMMIT is issued after EVERY SQL command you issue.

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