Subject | Re: [IBO] ServerAutoCommit issue |
---|---|
Author | Helen Borrie |
Post date | 2005-07-24T03:01:04Z |
At 02:47 AM 24/07/2005 +0000, you wrote:
Can you trace what's happening in the monitor when that StartTransaction
call is made?
Do you code this as
if not MyDM.MyTransaction.Started then
MyDM.MyTransaction.StartTransaction;
?
What versions of everything are you using?
How are you hooking up the transaction object to the connection object and
your statement objects?
What happens if you delete that transaction object in the IDE and replace
it with a new one of the same name?
Helen
>--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:Hmm, quite weird. begin "20 questions"...
> > At 11:26 PM 23/07/2005 +0000, you wrote:
> > >Hi All,
> > >
> > >I'm using a TIB_Transaction component in my data module. The
> > >ServerAutoCommit property is set to False in the object inspector.
> > >I've grepped my code and the property isn't being changed anywhere.
> > >
> > >However, when I call the StartTransaction method, I get an error
> > >"Explicit trans. not allowed with ServerAutoCommit". I have to
> > >manually set the ServerAutoCommit to False right before calling the
> > >StartTransaction to avoid the error.
> > >
> > >What would cause this property to be set to True?
> >
> > It shouldn't. Open your DFM in text mode and search for
>ServerAutoCommit
> > and see what that turns up...
> >
> > I'd also want to double-check that you haven't accidentally inserted
>an IBX
> > IBTransaction (or some other TIB-- object) into your application
> > somewhere...IBO's components all begin with either "TIBO" or "TIB_"
>(note
> > the underscore).
> >
>Hi Helen,
>
>There's nothing in the DFM.
Can you trace what's happening in the monitor when that StartTransaction
call is made?
Do you code this as
if not MyDM.MyTransaction.Started then
MyDM.MyTransaction.StartTransaction;
?
What versions of everything are you using?
How are you hooking up the transaction object to the connection object and
your statement objects?
What happens if you delete that transaction object in the IDE and replace
it with a new one of the same name?
Helen