Parameter into the IN clause

[FCS]

Hello,

Is it possible to send a parameter into IN clause, for example:
SELECT * FROM TABLE WHERE id IN (:id);
where ParamByName(id) = '5,6,7,8';

Regards
Michal

[AlexP]

Hello,

You cannot use parameters in the IN operator. To implement such behavior, you can use macros:

Code: Select all

  UniQuery1.SQL.Text := 'select * from dept where deptno in (&macro1)';
  UniQuery1.MacroByName('macro1').Value := '10,20,30';
  UniQuery1.Open;

[FCS]

Thanks

Regards
Michal

[AlexP]

If you have any further questions, feel free to contact us.