Subject | RE: IB_TRANSACTION PROBLEM |
---|---|
Author | Peter |
Post date | 2011-04-05T06:20:16Z |
Hi,
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.
Thanks,
Peter Tan
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.
Thanks,
Peter Tan