What is the best method to minimize overhead by the server when I want
to execute a ib_query again, but with new parameters (in BeforeOpen
event) and new "where" criteria (in PrepareSQL)?
I've tested that theese works (in the sense that PrepareSQL and
BeforeOpen events are executed, and the right dataset is returned):
(Second time here, so the query is still open)
a) Close; InvalidateSQL
b) Close; Unprepare;
c) Unprepare;
if Active then Refresh else Open
which is better? a), b) or c)? Another one?

Thanks
Marco Menardi