Harald,

You can use:

qry.invalidatesql;
qry.refresh;

Luiz.

----- Original Message -----
From: Harald Klomann <nibler@...>
To: IBO <IBObjects@egroups.com>
Sent: Wednesday, November 22, 2000 12:30 PM
Subject: [IBO] How to force a prepare


> Hi,
>
> in a TIB_Query, I have to alter the SqlWhereItems.
> Since this take effekt only in the OnPrepare event,
> I have to force a prepare. If I do a UnPrepare and
> after a Prepare, it is a bit time consuming..
> If I do it using Query.Search and then Query.Post
> it´s much faster, but the controls are going to searchmode
> for a short time.
>
> What is the best way to force TIB_Query to reprepare ?
>
> Thanks,
> Harald Klomann
>
>
>
>
>