Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Hi John
$ cannot be rushmore optimized. It would be a little better if you did ...
cSearch = upper(alltrim(m.cSearch))
SET FILTER TO cSearch $ alltrim(upper(name))
This goes for the SQL suggested by Manoj too.
>I am using the following code to set a filter of a table which then display the results in a list box.
>
>SET FILTER TO ALLTRIM(UPPER(csearch)) $ ALLTRIM(UPPER(Name)) IN Customer
>
>If there is only one record that matches the filter it works ok but if there are more that one a wait window pops up saying Filter cleared and the list box goes grey.
>
>Any ideas.
>
>Also the above code is not rush more optimised is there a better way.
>
>John
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement