[Erik Sowa]

I am using Database Explorer to look at the contents of a database. I start my connection with “auto-commit” and “commit on close” unchecked, so any changes I make by accident won’t survive my browsing session. Now I decide I do want to edit some table contents with the “Edit data” function. How do I invoke commit on the “edit data” changes? I can’t seem to find a UI control to invoke commit.

[Brian Fernandes]

Erik,

Unfortunately, there isn’t a UI control to commit your changes.

What you would need to do is finish the editing in that view and then execute the commit statement yourself in the SQLEditor.

Something like “commit;” should do the trick.

Do let us know if you require further assistance.

[Author]

Posts