Subject RE: AGAIN - [IBO] Search question
Author Nico Callewaert
If I would remove the InvalidateSQL, the statement will not reprepare again.
To set the SQLWhereItems in the OnClick event of a checkbox won't work
because, the only place you can have SQLWhereItems defined is in the
OnPrepare clause of the query. So when a user clicks the checkbox, I need
to Reprepare the statement, so the correct SQLWhereItems is set in the
OnPrepare event.

-----Oorspronkelijk bericht-----
Van: Harald Klomann [mailto:nibler@...]
Verzonden: donderdag 29 maart 2001 10:06
Onderwerp: Re: AGAIN - [IBO] Search question

Nico Callewaert wrote:
> Hi,
> I changed the OnPrepare statement of the query like this :
> if CheckBox1.Checked then
> else

CONTAINING is not case sensitive, so you will not need the UPPER here

> After the user selects another option, I do a InvalidateSQL, so I'm sure
You should not need to call InvalidateSQL, because it´s a build in by the

Did you have a look at the SearchingLinks.dpr in the Samples directory ?
Here you can see how to setup this stuff.


Yahoo! Groups Sponsor

Click Here to Find Software Faster

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]