Information générale
Catégorie:
Codage, syntaxe et commandes
>I have a TEST field which contains something like 1,2,5,18,23,32,33,34.
>
>I would like to compare a value within this field value.
>
>For example, I would like to do something like
>
>IF INLIST(TEST,'23')
> ...
>ENDIF
>
>But, this is not working. How can I process this validation?
if ",23," $ ","+alltrim( TEST)+","
...
This the best way I know. Please note that it's very important to add commas before and after TEST (otherwise you can find 23 in 423 for example even if 23 is not there). A good idea is to keep ",1,2,5,18,23,32,33,34," in TEST, not "1,2,5,18,23,32,33,34". It's faster.
Vlad
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