Subject | automatic search field for IB_SearchEdit |
---|---|
Author | Rick Roen |
Post date | 2004-12-18T17:32:28Z |
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
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