Synametrics Technologies

Hi, I am a current user for winsql, and the database is Oracle. I have disable the auto commit for it. I would like to know how to rollback and commit a transaction without right clik the mouse adn choose that 2 option. Thanks and regards.

Hi, There are two ways to do this. 1. Let WinSQL do the rollback and commit for you by selecting appropriate item from the pop-up menu in the query window. Click the right mouse button to make the pop-up menu visible 2. Write either ROLLBACK or COMMIT in the query window and manually change the state of the transaction.