Subject | Re: AGAIN - [IBO] Search question |
---|---|
Author | Harald Klomann |
Post date | 2001-03-29T08:05:56Z |
Nico Callewaert wrote:
Did you have a look at the SearchingLinks.dpr in the Samples directory ?
Here you can see how to setup this stuff.
Harald
>CONTAINING is not case sensitive, so you will not need the UPPER here
> Hi,
>
> I changed the OnPrepare statement of the query like this :
>
> if CheckBox1.Checked then
> SQLWhereItems.Add ('UPPER (NAME) STARTING WITH :NAME');
> else
> SQLWhereItems.Add ('UPPER (NAME) CONTAINING :NAME');
> After the user selects another option, I do a InvalidateSQL, so I'm sure theYou should not need to call InvalidateSQL, because it´s a build in by the SearchEdit.
Did you have a look at the SearchingLinks.dpr in the Samples directory ?
Here you can see how to setup this stuff.
Harald