Helen,
I'm familiar with commit/rollback for writes/updates but hadn't been aware
that it applied to selects.

Thanks,
Ray

> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: 10 October 2001 11:06
> To: ib-support@yahoogroups.com
> 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 · http://www.interbase2000.org
> _______________________________________________________
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Get your FREE VeriSign guide to security solutions for your
> web site: encrypting transactions, securing intranets, and more!
> http://us.click.yahoo.com/UnN2wB/m5_CAA/yigFAA/dpFolB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

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.