HMGforum.com

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!

Revolutionary

Thanks a lot Mr. Diamond

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

Viva HMG, viva HMG friendship

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

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

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.

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

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.

Very nice work! Thanks for sharing, Rathi!

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

Very good job our diamond-friend ! Congrats, very usefull ! Thanks for your sharing !

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 ...