C/AL Syntax

iqbalmad
iqbalmad Member Posts: 180
edited 2006-05-09 in NAV/Navision Classic Client
SETFILTER(fieldname, NOT variable)

Can some1 tell me the correct syntax in C/AL.

Note that the variable is of data type CODE.

Thnkx

Comments

  • Albertvh
    Albertvh Member Posts: 516
    Hi iqbalmad

    The correct syntax would be something like this

    SETFILTER(FieldName,'<>%1',VARIABLE);
  • DenSter
    DenSter Member Posts: 8,307
    The second parameter of SETFILTER must be text type. If you want to do (fieldname,variable) you can do SETRANGE(fieldname,variable). This only works for ranges and single values though.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Albertvh
    Albertvh Member Posts: 516
    The second parameter of SETFILTER must be text type.

    Not if you are substituting the %1 in the SETFILTER statement. Then you have to have a matching type field.
    eg SETFILTER("Posting Date",'%1',WORKDATE);
    SETFILTER(Amount,'<>%1',VarAmount); // VarAmount type Decimal
    SETFILTER("No.",'%1..%2',Var1,Var2); // Var1 & Var2 type Code
    :)
  • DenSter
    DenSter Member Posts: 8,307
    In which case you are representing the value of a non-text type in a text type variable. The second parameter is a text type.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories