Post changes button

[killer]

Hi

I can't seem to grasp the purpose of the 'post changes' button. In which situations would it be useful to post changes without committing?
As far as i've been able to figure out, when you post something it has the same effect as if you executed an update/insert/delete statement, but can the posted data perhaps be seen elsewhere?

Hoe someone can enlighten me, because it bugs me that I have to press the post+lock+commit buttons everytime I try to make an update, when I don't see the point

Regards

Killer

 

[Marco Kalter]

Separating the Post (update, insert, delete) operation from the Commit operation, allows you to perform transactions that are greater than just one Post operation, and also allow you to test constraints and triggers without actually modifying the database (if you subsequently rollback).

However, you can simply enable the "AutoCommit posted records" preference if this is of no use to you (Tools > Preferences > SQL Window page).

 

[GiorgioC]

Hi,
I'm searching an option to set to have the reverse behavior: I wish to have the way to do an "AutoPost" for all the transactions when I do the Commit operation.
Any suggestions?

 

[Marco Kalter]

There is currently no option for this. It is very similar to the AutoCommit option though.