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