how i can use ODBC SQL Query like with params

[eldonfsr]

Hi on paramas we can assign the field name witch we need find or select informatioon

is possible to use    select * from pn where  PnDetail like :%ItemDescription%
using params


   

[paweld]

Code: Pascal  [Select][+][-]

1. . SQLQuery1.SQL.Text := 'select * from pn where  PnDetail like :param1';
2.   SQLQuery1.paramByName('param1').AsString := '%ItemDescription%';

Or

Code: Pascal  [Select][+][-]

1. . SQLQuery1.SQL.Text := 'select * from pn where  PnDetail like ''%''+:param1+''%''';
2.   SQLQuery1.paramByName('param1').AsString := 'ItemDescription';

[eldonfsr]

Ok Great Thanks...

[Zvoni]

This works on ONE single comparison.
If you want to compare with a Like against multiple criteria, it's a different kettle of fish
.. you know.... those blasted OR-constructs ".... WHERE PnDetail LIKE '%Crit1%' OR PnDetail LIKE '%Crit2%' OR ....."
There is an "elegant" way to boil that down