Page 2 of 2
Re: combosearchgrid with sqlite
Posted: Wed Nov 30, 2016 8:03 pm
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
Re: combosearchgrid with sqlite
Posted: Thu Dec 01, 2016 9:17 am
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
Re: combosearchgrid with sqlite
Posted: Tue Dec 06, 2016 11:24 am
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