Subject Re: [IBO] OnPrepareSQL
Author Markus Ostenried
At 14:52 Thursday, 22.05.2003 +0100, you wrote:
>All,
>
> I am in the middle of building a search screen that will be used in
> the OnPrepareSQL event. The only problem I have is that the OnPrepareSQL
> only gets called the once, when I open the IB_Query. I've had a look at
> the SearchLinks example and I can't see what is different between my app
> that the example app.
>
>Anyone got any hint/tips?

Marcus,

have a look at the help for "InvalidateSQL". Just do
IB_Query1.InvalidateSQL;
IB_Query1.Refresh;
then your OnPrepareSQL event will be executed immediately.

HTH,
Markus