Thanks Alves,
that´s it !

Harald

Luiz Alves wrote:

> 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
> >
> >
> >
> >
> >
>