SQLite3 filter and FindFirst/FindNext

[JanRoza]

I already search the forum for SQLite examples but alas there aren't too many.
In my program I have an Edit-box where the user can enter a value to be searched in the SQLite database. When found the dbgrid should be positioned on the found record.
I used following construction to do a search:

Code: [Select]


   tblAdressen.Filter := 'Lower(VolleNaam) like ''%' + LowerCase(EdtZoeken.Text) + '%''';
   if not tblAdressen.FindFirst
   then begin
           ..........
   end;


Unfortunately every search comes back empty although I know for sure the value is in the database.
Am I using a wrong syntax here?
How to search the SQLite database and get the dbgrid positioned on the found record?

Jan

[LuizAmérico]

Filter is not implemented in SqliteDataset.
Use Locate/LocateNext instead.

[JanRoza]

Thank you Luiz,

Once more you're my rescue in desperate times  
I'll switch to locate and try that way.

If I continue this long enough than one day there won't be anything left to ask about SQLite  :lol:

Jan