how i can use ODBC SQL  Query like with params
lazarus / 16-Databases

----------------------------------------------------------------------
eldonfsr · 2025-01-31 15:17

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 · 2025-01-31 16:38

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i .
SQLQuery1.SQL.Text := 'select * from pn where  PnDetail like
:param1';  SQLQuery1.paramByName('param1').AsString :=
'%ItemDescription%';Or
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i .
SQLQuery1.SQL.Text := 'select * from pn where  PnDetail like
''%''+:param1+''%''';  SQLQuery1.paramByName('param1').AsString :=
'ItemDescription';

----------------------------------------------------------------------
eldonfsr · 2025-01-31 19:46

Ok Great Thanks...

----------------------------------------------------------------------
Zvoni · 2025-02-10 07:42

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