[RBASE-L] - Re: ON KEY PRESS

[Lawrence Lustig]

<<
   SET VAR vWhereClause = +
   ('Control#
LIKE'&.vSearchString&'OR ' + +
    'DistName
LIKE'&.vSearchString&'OR ' + +
    'ShipState LIKE'&.vSearchString)
>>

The ORs make this non-optimizable. However, you can rewrite the query to use 
UNION to combine the results of three separate queries and, if you index 
Control#, DistName, and ShipState, you will get an optimized search.

--
Larry

>