ComboSearchGrid

HMG Samples and Enhancements

Moderator: Rathinagiri

User avatar
Rathinagiri
Posts: 5250
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 167 times
Been thanked: 165 times
Contact:

ComboSearchGrid

Post by Rathinagiri » Wed Apr 24, 2013 4:56 pm

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 3239 times
Please give your suggestions, we can make a better control!
combosearchgrid.zip
(7.4 KiB) Downloaded 508 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
esgici
Posts: 4472
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 352 times
Been thanked: 104 times
Contact:

Post by esgici » Wed Apr 24, 2013 7:17 pm

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: 258
Joined: Thu Mar 21, 2013 12:22 am
Location: California
Been thanked: 1 time

Post by CalScot » Wed Apr 24, 2013 8:42 pm

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: 344
Joined: Wed Nov 21, 2012 7:14 pm
Location: México
Has thanked: 1 time
Been thanked: 4 times

Post by Leopoldo Blancas » Wed Apr 24, 2013 9:14 pm

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: 5250
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 167 times
Been thanked: 165 times
Contact:

Post by Rathinagiri » Thu Apr 25, 2013 3:46 am

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: 5250
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 167 times
Been thanked: 165 times
Contact:

Post by Rathinagiri » Thu Apr 25, 2013 3:58 am

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: 3070
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 180 times
Been thanked: 96 times
Contact:

Post by mol » Thu Apr 25, 2013 5:32 am

Very nice work! Thanks for sharing, Rathi!

User avatar
esgici
Posts: 4472
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 352 times
Been thanked: 104 times
Contact:

Post by esgici » Thu Apr 25, 2013 11:21 am

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
Has thanked: 100 times
Been thanked: 179 times

Post by Pablo César » Thu Apr 25, 2013 12:08 pm

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: 2090
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Has thanked: 115 times
Been thanked: 15 times
Contact:

Post by danielmaximiliano » Thu Apr 25, 2013 6:56 pm

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 390 times
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`.HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. : +54901169026142
Telegram Name : DaNiElMaXiMiLiAnO

Post Reply