9 Replies Latest reply: Jan 14, 2011 7:44 PM by John Witherspoon RSS

    Which operators are allowed for the 'where' clause when doing LOAD from residents?

    Andreas Karlsson

      Hi guys,

      I want to load the ID field from a resident if another field named CODE in the example below has certain values.

      It seems that the in-operator isn't allowed

      (I cannot find which operators that are allowed for the LOAD statement only for the SQL SELECT statement)

      Do I have to add 13 WHERE CODE='A1 AND CODE='A7' .....and so on ?

      LOAD
      ID
      RESIDENT A where CODE in ("A1","A7","B1","B3","B7","L1","M1","N1","C1","D1","E1","F1","G1");

      /Andy