ComboSearchGrid
Moderator: Rathinagiri
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
ComboSearchGrid
Hi,
Here I am sharing my experimentation for multi-column combosearchgrid based on Esgici's ComboSearchBox. I was very much longing for a control like in MS Access with multi-column combobox. Now it is possible.
Features of ComboSearchGrid:
- I have used SQLite temporary database and table to optimize the search
- Since the combosearchgrid is based on Virtual Grid there is no limitation as to the number of rows! In the sample I have used 10000 rows. But you can check for more rows and find out how fast it is. Actually there is no program degradation because of the number of rows.
- The text is searched in all the columns.
- Anywhere search is also available
- You can show/hide the headers too.
- SQLite operations are totally hidden and you need not know anything about SQLite.
Please give your suggestions, we can make a better control!
Here I am sharing my experimentation for multi-column combosearchgrid based on Esgici's ComboSearchBox. I was very much longing for a control like in MS Access with multi-column combobox. Now it is possible.
Features of ComboSearchGrid:
- I have used SQLite temporary database and table to optimize the search
- Since the combosearchgrid is based on Virtual Grid there is no limitation as to the number of rows! In the sample I have used 10000 rows. But you can check for more rows and find out how fast it is. Actually there is no program degradation because of the number of rows.
- The text is searched in all the columns.
- Anywhere search is also available
- You can show/hide the headers too.
- SQLite operations are totally hidden and you need not know anything about SQLite.
Please give your suggestions, we can make a better control!
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: ComboSearchGrid
Revolutionary
Thanks a lot Mr. Diamond
By the way, I'm not single author of ComboSeacrhBox, only humble starter
Viva HMG, viva HMG friendship
Thanks a lot Mr. Diamond
By the way, I'm not single author of ComboSeacrhBox, only humble starter
Viva HMG, viva HMG friendship
Viva INTERNATIONAL HMG
Re: ComboSearchGrid
Hi, Rathinagiri.
That is not only "Way Cool!!", but the speed is simply amazing!!!
It's also very timely for me, as I think it may just be the solution to my problem of getting multiple fields in the dropdown list that I've described in another thread; I'll try to implement it as soon as I can.
Thank you! (And Esgici, too!)
CalScot
That is not only "Way Cool!!", but the speed is simply amazing!!!
It's also very timely for me, as I think it may just be the solution to my problem of getting multiple fields in the dropdown list that I've described in another thread; I'll try to implement it as soon as I can.
Thank you! (And Esgici, too!)
CalScot
-
- Posts: 388
- Joined: Wed Nov 21, 2012 7:14 pm
- Location: México
Re: ComboSearchGrid
Hola Rathinagiri...
En verdad rápido y muy limpio a la hora de teclear... Voy a ver si lo puedo adaptar a un ejemplo mio...
Gracias por compartir...
Saludos
Polo
*-----------------------------------------------------------------------------------------------------------------------
Hello Rathinagiri ...
Truly fast and very clean when typing ... I'll see if I can adapt to an example mine ...
Thanks for sharing ...
regards
Polo
En verdad rápido y muy limpio a la hora de teclear... Voy a ver si lo puedo adaptar a un ejemplo mio...
Gracias por compartir...
Saludos
Polo
*-----------------------------------------------------------------------------------------------------------------------
Hello Rathinagiri ...
Truly fast and very clean when typing ... I'll see if I can adapt to an example mine ...
Thanks for sharing ...
regards
Polo
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: ComboSearchGrid
Thanks a lot friends. I will do some enhancements like header click to sort by the column, specifying the column source from a dbf etc.
The key to the speed here is, the array is loaded to the table only once at the time of definition of the control. After that it is only a set of records from a SQLite query. The virtual grid requires only the data to be shown in the screen anytime and not the whole set.
The key to the speed here is, the array is loaded to the table only once at the time of definition of the control. After that it is only a set of records from a SQLite query. The virtual grid requires only the data to be shown in the screen anytime and not the whole set.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: ComboSearchGrid
Starting and trying new things is more important. Isn't it? You had done a wonderful job in this Esgici.esgici wrote: By the way, I'm not single author of ComboSeacrhBox, only humble starter
Apart from starting, you had actually cleaned up the mess and made the code look neat and bug free.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: ComboSearchGrid
Very nice work! Thanks for sharing, Rathi!
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: ComboSearchGrid
Thanks Rathi
Nevertheless your work was further than mine on ComboSearchBox.
Without your and Maestro's reinforcements newer be exit such thing.
Thanks again.
Viva HMG
Nevertheless your work was further than mine on ComboSearchBox.
Without your and Maestro's reinforcements newer be exit such thing.
Thanks again.
Viva HMG
Viva INTERNATIONAL HMG
- Pablo César
- Posts: 4059
- Joined: Wed Sep 08, 2010 1:18 pm
- Location: Curitiba - Brasil
Re: ComboSearchGrid
Very good job our diamond-friend ! Congrats, very usefull ! Thanks for your sharing !
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
- danielmaximiliano
- Posts: 2612
- Joined: Fri Apr 09, 2010 4:53 pm
- Location: Argentina
- Contact:
Re: ComboSearchGrid
Hola a Todos :
Modifique el ejemplo para poder utilizarlo en mis aplicaciones y veo que funciona erraticamente en HMG.3.1.2
le envie este ejemplo al amigo POLO y me devuelve un ejecutable compilado en HMG.3.0.46 funcionando correctamente.
la tabla fue sacada del ejemplo Agenda...
Translate Google
Hi Everyone:
Modify the example to use it in my applications and see which works erratically in HMG.3.1.2
This example will send the friend POLO and returns a compiled executable me in HMG.3.0.46 working properly.
the table was taken from the example Agenda ...
Modifique el ejemplo para poder utilizarlo en mis aplicaciones y veo que funciona erraticamente en HMG.3.1.2
le envie este ejemplo al amigo POLO y me devuelve un ejecutable compilado en HMG.3.0.46 funcionando correctamente.
la tabla fue sacada del ejemplo Agenda...
Translate Google
Hi Everyone:
Modify the example to use it in my applications and see which works erratically in HMG.3.1.2
This example will send the friend POLO and returns a compiled executable me in HMG.3.0.46 working properly.
the table was taken from the example Agenda ...
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO