mibuso.com
Home› NAV/Navision Classic Client

Logical operator......

FakerulesFakerules Member Posts: 50
edited 2009-11-30 in NAV/Navision Classic Client
OK I know that '|' is used as a OR operator and '&' operator is used for AND operator.

now how to put a query as........ all elements but not say x,y,z.

Answers

  • ShedmanShedman Member Posts: 194
    You could try 
    <>X&<>Y&<>Z

    or 
    IF var NOT IN [X,Y,Z] THEN ...
  • danlindstromdanlindstrom Member Posts: 130
    Shedman wrote:
    You could try 
    IF var NOT IN [X,Y,Z] THEN ...

    Should be
    IF NOT(var IN [X,Y,Z]) THEN...
    Regards
    Dan Lindström
    NCSD Navision 2.00 since 1999 (Navision Certified Solution Developer)
    MBSP Developer for Microsoft Dynamics NAV 2009
Sign In or Register to comment.