Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2008 Server
>Hi
>
>I would like to set filter to a not empty condition
>
>Something like: Set filter to not empty(myfield).
>
>But it does not work because this is not the correct syntax.
>
>Is thre anyway to achieve it or set filter is not the solution ?
>
>I tried Set filter to not myfield # "", but it is not the same.
>
>
>Happy New Year to everybody.
>
>Moises
EMPTY() is not Rushmore optimizable unless you add an INDEX ON EMPTY(myfield). That is a non-discriminating index. If you already have another index on myfield like this... INDEX ON UPPER(myfield) TAG xmyfield
then the following will work.
lcSpaces=space(len(myfield))
SET FILTER TO UPPER(myfield) # m.lcSpaces
You won't need a new index and it will optimize.
Précédent
Suivant
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