Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INLIST syntax
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00019640
Message ID:
00019649
Views:
36
>>>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 it's numeric don't use quotes...
>
>No, INLIST can't work within a string.
>
>The INLIST syntax is usually IF INLIST(gcMonth,'January','February','March'). I just mentioned it to show the result I wanted to get.

I think I see. No, I don't think you can use Inlist like that. You might need to parse your string up between commas to get an accurate check using ATC, maybe.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform