combosearchgrid with sqlite

Moderator: Rathinagiri

giampy
Posts: 4
Joined: Sun Oct 30, 2016 5:35 pm
Location: Marcon, Venice

Re: combosearchgrid with sqlite

Post by giampy »

Ciao a tutti,
Thank you for answers and help.
For Serge, now I see to adapt your code to SQLite. My aim is to have an incremental search with texbox and a grid and sqlite.
Giampaolo

User avatar
serge_girard
Posts: 2484
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Has thanked: 781 times
Been thanked: 147 times
Contact:

Post by serge_girard »

Hi Giampaolo,

That easier than working with DBF. Just ALLTRIM the filters and put '%' at the begin and at the end of the string and finaly something like this:

Code: Select all

cQuery1	+= " AND    F1  LIKE  '%"   + STRVALUE(c1)     + "%' "
cQuery1	+= " AND    F2  LIKE  '%"   + STRVALUE(c2)     + "%' "
For dates a bit different

Serge

User avatar
mustafa
Posts: 962
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Been thanked: 187 times
Contact:

Post by mustafa »

Hola amigo giampy:
Mirate este sample Sqlite que publiqué
viewtopic.php?f=9&t=4795&p=45549&hilit= ... ite#p45549
Mira la opción de Search -> Code o Name
Saludos
*----------------- Google ------------------------------*
Hi friend giampy:
Look at this Sqlite sample I published
viewtopic.php?f=9&t=4795&p=45549&hilit= ... ite#p45549
Look at the Search -> Code or Name
Regards
Mustafa

Post Reply