Hi,

At May 22, 2003, 10:52, marcus.monaghan@... 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?

Call IB_Query.InvalidateSQL, then IB_Query.Refresh. InvalidateSQL will
force the query to reprepare on the next Refresh or Open, and the
OnPrepareSQL event will be used.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)