Use variable in IN statement

Gianfranco

Anybody succeeded in using a variable with a IN statement?
Sort of
IF AnyRecord.Field IN [TextVariable] THEN ...
where TextField should contain something 'VALUE1,VALUE2,VALUE3'.

Thanks

NavNab

I don't know which NAV version you use! If NAV2009 SP1 RTC or newer then you can try .NET interoperability using List.Contains

Slawek_Guzek

IF SomeVar IN [TextVariable] THEN ... has no chance to work. You can try to think of IN operator as a series of ORs on every argument inside the square brackets. In your case IF SomeVar IN [TextVariable] THEN... is equivalent to IF SomeVar = TextVariable THEN... as you have only one argument inside the square brackets.

Without restoring to .NET you can write a function performing the check, someting like this:

Contains(aVar, aList)
{
  EXIT(
   (aVar = aList)
    OR (STRPOS(aList,    aVar+',') = 1)
    OR (STRPOS(aList, ','+aVar+',') > 1)
    OR (STRPOS(aList, ','+aVar) = STRLEN(aList) - STRLEN(aVar) )
  )
}

tarkmyler

2009r2 classic client - square brackets for IN statement