You need to Unprepare the query, not just close it.
Although, this should do that automatically I think.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Tobias Giesen" <tobias_subscriber@...>
To: "IBObjects@yahoogroups. com" <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
"Invalid
> transaction handle (expecting implicit transaction start)". How can I
> prevent that?
>
> Thanks.
> Tobias
>
> ----------------------------------------
> Tobias Giesen, Composer - ICQ # 97626829
> http://www.tobiasgiesen.de