Subject | RE: [IBO] RE: IB_TRANSACTION PROBLEM |
---|---|
Author | Support List |
Post date | 2011-04-13T08:22:59Z |
Peter,
Thanks,
Jason LeRoy Wharton
> I just migrated to IBO Version 4.9 Release 12 Build 233 from 4.8 Build 7I have confirmed that there is indeed a bug here. I'm working on a fix now.
> (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.
Thanks,
Jason LeRoy Wharton