Subject | assigning a query to a different DB connection |
---|---|
Author | Tobias Giesen |
Post date | 2001-09-19T23:45:36Z |
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
Check out TGTools, my Plug-In Collection
for Finale: http://www.tgtools.de
----------------------------------------
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
Check out TGTools, my Plug-In Collection
for Finale: http://www.tgtools.de
----------------------------------------