SQLite3 filter and FindFirst/FindNext
lazarus / 16-Databases

----------------------------------------------------------------------
JanRoza · 2007-12-16 19:46

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 · 2007-12-18 10:07

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

----------------------------------------------------------------------
JanRoza · 2007-12-18 11:46

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