Subject RE: [ib-support] Commit/Rollback Reads?
Author Ray Drew
I'm familiar with commit/rollback for writes/updates but hadn't been aware
that it applied to selects.


> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: 10 October 2001 11:06
> To:
> Subject: Re: [ib-support] Commit/Rollback Reads?
> 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.
> cheers,
> Helen
> All for Open and Open for All
> InterBase Developer Initiative ยท
> _______________________________________________________
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Get your FREE VeriSign guide to security solutions for your
> web site: encrypting transactions, securing intranets, and more!
> --------------------------------------------------------------
> -------~->
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to

CONFIDENTIALITY - The information in this e-mail and any attachment is
confidential and is intended only for the named recipient(s). The E-mail
may not be disclosed or used by any person other than the addressee, nor may
it be copied in any way. If you are not a named recipient please notify the
sender immediately and delete any copies of this message.