Subject automatic search field for IB_SearchEdit
Author Rick Roen
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.

TIA

Rick