How to add params to IBCQuery

[abak]

Hello,
I tried to add them in params editor but it is always locked !
How can I do it at Designtime and Runtime ?
Thx.

[ViktorV]

The Parameters tab in IBCQuery Editor is not designed for parameter addition. Using it, you can edit parameters, that are automatically generated on the basis of the query on the SQL tab.
To add parameters in runtime, you can use the following code:

Code: Select all

  IBCQuery.ParamCheck := False;
  IBCQuery.Params.Clear;
  IBCQuery.SQL.Text := 'select * from dept where deptno = :deptno';
  IBCQuery.Params.CreateParam(ftInteger, 'deptno', ptInput);
  IBCQuery.ParamByName('deptno').AsInteger := 10;
  IBCQuery.Open;

[abak]

Thank you ViktorV.

[ViktorV]

Feel free to contact us if you have any further questions about IBDAC.