Subject RE: [IBO] Changing a parameter opens query
Author Norman Dunbar
Hi Christoph,

Don't you have to close a stored proc before changing parameters ?
I think it's something to do with a bug in interbase/firebird (the older
versions I presume).
It is mentioned in the GSG that this is needed.


PS. I don't think changing the parameters affect a normal query thogh, only
the stored proc. Maybe Jason is closing in the background when a parameter
change is made while the 'query' is open. I haven't looked in the source to
find out though.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
Tel: 0113 289 6265
Fax: 0113 289 3146

-----Original Message-----
From: cb_nos [mailto:cb_nos@...]
Sent: Wednesday, June 18, 2003 10:36 AM
Subject: [IBO] Changing a parameter opens query


I just found out that when I change the parameter of an already open
query, then the query will obviously be re-opened (found it out by
opening a stored procedure which does inserts).

Is this intended behaviour? If yes, then everything's fine, I just
need to know! ;-)

Kind regards

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to

This email is intended only for the use of the addressees named above and may be confidential or legally privileged. If you are not an addressee you must not read it and must not use any information contained in it, nor copy it, nor inform any person other than Lynx Financial Systems or the addressees of its existence or contents. If you have received this email and are not a named addressee, please delete it and notify the Lynx Financial Systems IT Department on 0113 2892990.