Hello, i was testing lazarus for the first time, coming from long use of Delphi.
In delphi i use this way with TClientDataset with no problems, but now in Lazarus ...
I have a TSqlQuery to filter pressing a button in this way:
SQLQuery1.Filtered:= false;
SQLQuery1.filter := 'descr like ' + QuotedStr('%' +Edit1.text+'%');
SQLQuery1.Filtered:= true;
Where "descr" is the name oy my field where i want to search, but gives the error
Index based on unknown field "like".
This also using "*" instead of "%".
What is wrong? why lazarus thinks "like" is a field ?
If i use "descr = " instead of "descr like" its works fine!
The DB is Sqllite... Thanks for help,
Dario