Searching more than one Criteria
lazarus / 16-Databases

----------------------------------------------------------------------
linuxdesire · 2020-08-12 18:38

I have a Tform1.btnSearchClick

I can search by "title" but when I try to put in "actor" it gives me
an error. Here is what I have that is working.

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 procedure
TForm1.btnSearchClick(Sender: TObject);begin  SQLQuery1.locate('Title'
,edtSearch1.Text,[loCaseInsensitive,loPartialKey]);end;              
                                                                 

If I try to put in 'Actor' I get the error:
unit1.pas (94,85)Error: Wrong number of parameters specified for call
to "Locate"

It has the squiggly line under the ); at the end of the line.



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 procedure
TForm1.btnSearchClick(Sender: TObject);begin 
SQLQuery1.locate('Title',
'Actor',edtSearch1.Text,[loCaseInsensitive,loPartialKey]);end;

----------------------------------------------------------------------
paweld · 2020-08-12 19:10

If you want to take multiple columns, enter them in one string,
separated by a semicolon. And the searched values as an array.
https://wiki.freepascal.org/locate

----------------------------------------------------------------------
mangakissa · 2020-08-13 08:37

But you can't search in two fields with one criteria.
If you want, you have to search twice.