ComboSearchGrid

HMG Samples and Enhancements

Moderator: Rathinagiri

User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

ComboSearchGrid

Post by Rathinagiri »

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.
csg.jpg
csg.jpg (60.23 KiB) Viewed 7630 times
Please give your suggestions, we can make a better control!
combosearchgrid.zip
(7.4 KiB) Downloaded 819 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: ComboSearchGrid

Post by esgici »

Revolutionary :!:

Thanks a lot Mr. Diamond :arrow:

By the way, I'm not single author of ComboSeacrhBox, only humble starter :oops:

Viva HMG, viva HMG friendship :D
Viva INTERNATIONAL HMG :D
User avatar
CalScot
Posts: 303
Joined: Thu Mar 21, 2013 12:22 am
Location: California

Re: ComboSearchGrid

Post by CalScot »

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
Leopoldo Blancas
Posts: 388
Joined: Wed Nov 21, 2012 7:14 pm
Location: México

Re: ComboSearchGrid

Post by Leopoldo Blancas »

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
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: ComboSearchGrid

Post by Rathinagiri »

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.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: ComboSearchGrid

Post by Rathinagiri »

esgici wrote: By the way, I'm not single author of ComboSeacrhBox, only humble starter :oops:
Starting and trying new things is more important. Isn't it? You had done a wonderful job in this Esgici.

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.
User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: ComboSearchGrid

Post by mol »

Very nice work! Thanks for sharing, Rathi!
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: ComboSearchGrid

Post by esgici »

Thanks Rathi :oops:

Nevertheless your work was further than mine on ComboSearchBox.

Without your and Maestro's reinforcements newer be exit such thing.

Thanks again.

Viva HMG :D
Viva INTERNATIONAL HMG :D
User avatar
Pablo César
Posts: 4059
Joined: Wed Sep 08, 2010 1:18 pm
Location: Curitiba - Brasil

Re: ComboSearchGrid

Post by Pablo César »

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
User avatar
danielmaximiliano
Posts: 2611
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Contact:

Re: ComboSearchGrid

Post by danielmaximiliano »

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 ...
demoComboSearchGrid.rar
(34.39 KiB) Downloaded 622 times
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
Post Reply