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 » Wed Nov 30, 2016 8:03 pm

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: 2348
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Has thanked: 590 times
Been thanked: 124 times
Contact:

Post by serge_girard » Thu Dec 01, 2016 9:17 am

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: 842
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Been thanked: 121 times
Contact:

Post by mustafa » Tue Dec 06, 2016 11:24 am

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