load * from wherever.qvd where fieldname in (valuelist);
and got the "garbage after statement" error. When I took out the "in" and replaced it with an equals sign it was happy. Can I not use "in" in a load statement where clause? Or did I get the syntax wrong?
Does anybody have the criterion syntax or a better way around this than lots of "or" statements?