Subject Re: [IBO] automatic search field for IB_SearchEdit
Author Helen Borrie
At 05:32 PM 18/12/2004 +0000, you wrote:

>Delphi 7
>I'm using a TIB_SearchEdit to locate a record in a Customer table,
>either by Customer number or name.
>Currently I have a radio group control that the user switches to
>determine the type of search - name or number. When this is
>changed, I modify the SQLWhere property of the IB_Query in the
>OnPrepareSQL event.
>This works fine, but I would like to make it a bit easier for the
>user by automatically switching the search from number to name. I
>can detect what they have entered by testing the "text" property of
>the search edit (like: if ( StrToIntDef( SE.Text, -1 ) = -1 ) then
>its a name rather than number.
>I'm looking for the best way (an event maybe) to react to the
>customer input to change the SQLWhere for the search.

Take a look at the SearchingLinks example in Samples.