Subject Re: [ib-support] Commit/Rollback Reads?
Author Helen Borrie
At 10:46 AM 10-10-01 +0100, you wrote:
>After running a select query in IBACCESS or IBQUERY I'm asked if I want to
>commit or rollback the transaction. A couple of questions..
>Do I have to do this in my app. code?

Yes, your app code has to start and complete transactions.

>What's the difference between committing and rolling back a select query?

If it's just a select, there is no difference - either will complete the transaction and release the rows.

If it's a metadata change, or a change to data, commit makes it permanent on the server, rollback undoes everything that happened inside your transaction's context since you started it.


All for Open and Open for All
InterBase Developer Initiative ยท