ServerAutoCommit includes the auto commit TPB item when starting a
transaction so that everything executed via that transaction will be
committed on the server immediately upon successful execution without the
client having to tell the server to commit the changes.

This should only be used in special circumstances as I think it could have
additional overhead, similar to having AutoCommit true and process a batch
of updates.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Rohit Gupta" <r.gupta@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 07, 2002 1:17 AM
Subject: Re: [IBO] TIBOQuery and Transaction


> What is the purpose of ServerAutoCommit ?
>
>
> ----- Original Message -----
> From: "Daniel Rail" <daniel@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, 7 October 2002 11:35 AM
> Subject: Re: [IBO] TIBOQuery and Transaction
>
>
> > At 06/10/2002 05:14 PM, you wrote:
> > >I execute a stor proc using TIBOQuery. The stor proc inserts a new
> > >record in a table. The transaction used by the query has autocommit set
> > >to true. I cannot see the new record (in IBConsole) until I execute the
> > >query again or close the app.
> >
> > Is the property ServerAutoCommit:=True as well? In the Transaction
> > component, you have the properties AutoCommit and ServerAutoCommit, make
> > sure both are set to true.
> >
> >
> > Daniel Rail
> > Senior System Engineer
> > ACCRA Group Inc. (www.accra.ca)
> > ACCRA Med Software Inc. (www.accramed.ca)