Transaction controls and settings
BEGIN / COMMIT / ROLLBACK is ignored when pressing "Execute Current Statement". Button / menu item for transaction control do not exists.
Changing auto-commit mode are helpful, too:
- auto-commit on
- auto-commit off => preserve error state
- auto-commit off with auto rollback
- auto-commit off with auto save point and rollback (emulates other dbs)
1
vote
![](https://secure.gravatar.com/avatar/6a042d749d7d5d779a54046ef1bc7868?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)