Subject Re: [IBO] assigning a query to a different DB connection
Author Jason Wharton
You need to Unprepare the query, not just close it.
Although, this should do that automatically I think.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Tobias Giesen" <tobias_subscriber@...>
To: "IBObjects@yahoogroups. com" <>
Sent: Wednesday, September 19, 2001 4:45 PM
Subject: [IBO] assigning a query to a different DB connection

> Hi!
> I have to change the DB connection for a query at run-time. I have two
> TIB_Connection components, and my query needs to switch between them. So I
> close the query, and change the dabase property, and the IB_Connection and
> IB_Transaction properties too.
> Are there any other precautions? I sometimes get the error message
> transaction handle (expecting implicit transaction start)". How can I
> prevent that?
> Thanks.
> Tobias
> ----------------------------------------
> Tobias Giesen, Composer - ICQ # 97626829