Subject Re: [IBO] RE: IB_TRANSACTION PROBLEM
Author Peter
Jason,

I think I will stick to version 4.8 for now, following your advice. I am still using D7. The only reason I am migrating to 4.9 is that I am using FB 2.5. I was just thinking you could have updated the code to make it work better with FB 2.5.

Peter


--- In IBObjects@yahoogroups.com, "Support List" <supportlist@...> wrote:
>
> Peter,
>
> > I just migrated to IBO Version 4.9 Release 12 Build 233 from 4.8 Build
> > 7 (beta).
> >
> > I have 2 components on a form:
> >
> > IB_Transaction1 [TIB_Transaction]
> > Properties:
> > IB_Connection := DataModule1.IB_Connection1
> > IB_Connection1 := DataModule1.IB_LocalConnection
> >
> >
> >
> > IBODelCFQuery [TIBOQuery]
> > Properties:
> > IB_Connection := DataModule1.IB_LocalConnection IB_Transaction =
> > IB_Transaction1 SQL := DELETE FROM CARRIED_FORWARDS
> >
> >
> > The code is:
> >
> > IB_Transaction1.StartTransaction;
> > try
> > IBODelCFQuery.ExecSQL;
> >
> >
> > When I run the code, I get the following error:
> >
> > ISC ERROR CODE:335544324
> > ISC ERROR MESSAGE: Invalid database handle (no active connection)
> >
> > Other parts of my software where IB_TRANSACTION are used also have
> > similar error messages. I didn't have this issue with 4.8.7. Have
> > there been any changes with the method IB_TRANSACTION is used.
> >
> > Please advise.
>
> I am not aware of anything that should have affected this.
>
> Will you please update to the latest Beta and test it using that?
> Also, I strongly advise that you avoid 4.9.x entirely if you are coming from
> 4.8.x. This is because I took a wrong turn and forced everything to ANSI
> string types as a way to migrate into Delphi 2009 Unicode strings. It wasn't
> until IBO 4.9.13.x that I got this all straightened out.
>
> It will be much easier to migrate your code to the latest Beta.
>
> Jason Wharton
>