Code: Select all
MyQuery.SQL.Text := 'select * from MyTable where MyField in (''A'', ''B'', ''C'')';
How to use this statement with parameters? I tried this:
Code: Select all
MyQuery.SQL.Text := 'select * from MyTable where MyField in (:MyField)';
MyQuery.ParamByName('MyField').ValueCount := 3;
MyQuery.ParamByName('MyField').Values[0].AsString := 'A';
MyQuery.ParamByName('MyField').Values[1].AsString := 'B';
MyQuery.ParamByName('MyField').Values[2].AsString := 'C';