Subject | Re: [IBO] TIBOQuery and Transaction |
---|---|
Author | Jason Wharton |
Post date | 2002-10-07T17:25:54Z |
Only set ServerAutoCommit to true if you really need it and know what you
are doing. If it is true, AutoCommit can be either true or false, doesn't
matter.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
-- We may not have it all together --
-- But together we have it all --
are doing. If it is true, AutoCommit can be either true or false, doesn't
matter.
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: "Daniel Rail" <daniel@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, October 06, 2002 3:35 PM
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)