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
combosearchgrid with sqlite
Moderator: Rathinagiri
- serge_girard
- Posts: 3178
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: combosearchgrid with sqlite
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:
For dates a bit different
Serge
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) + "%' "
Serge
There's nothing you can do that can't be done...
- mustafa
- Posts: 1162
- Joined: Fri Mar 20, 2009 11:38 am
- DBs Used: DBF
- Location: Alicante - Spain
- Contact:
Re: combosearchgrid with sqlite
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
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