HMG_aChoice + Grid = Incremental Search in Grid Cells
Moderator: Rathinagiri
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
HMG_aChoice + Grid = Incremental Search in Grid Cells
Hi,
First of all I wish to state why couldn't I use HMG's default in-place edit (using combobox).
1. HMG's Grid Inplaceedit combobox controls are not sorted. Therefore, we can't have incremental search.
2. The combobox items are fixed.
3. The returned value is the numeric index and not the string selected. I wanted to have the string value and not the numeric index because I will change the list items subsequently.
So, I started working this HMG_aChoice. I think now, it has some shape to be used inside in-place edit of grid.
Here I attach a sample, where in HMG_aChoice being used in grid.
I have three columns in the grid, namely Departments, Items and Quantity. The items list would change according to the department selection.
Kindly review the code and give your comments and suggestions.
First of all I wish to state why couldn't I use HMG's default in-place edit (using combobox).
1. HMG's Grid Inplaceedit combobox controls are not sorted. Therefore, we can't have incremental search.
2. The combobox items are fixed.
3. The returned value is the numeric index and not the string selected. I wanted to have the string value and not the numeric index because I will change the list items subsequently.
So, I started working this HMG_aChoice. I think now, it has some shape to be used inside in-place edit of grid.
Here I attach a sample, where in HMG_aChoice being used in grid.
I have three columns in the grid, namely Departments, Items and Quantity. The items list would change according to the department selection.
Kindly review the code and give your comments and suggestions.
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: HMG_aChoice + Grid = Incremental Search in Grid Cells
Hi Rathi
Good implementation, thanks
Some random thoughts :
- I couldn't understand functions of two (one at top and one bottom) separate text box.
- I couldn't change any existing value; when attempted cell become empty.
- (Probably by same cause) appended new row remain empty, I couldn't enter value.
Regards
--
Esgici
Good implementation, thanks
Some random thoughts :
- I couldn't understand functions of two (one at top and one bottom) separate text box.
- I couldn't change any existing value; when attempted cell become empty.
- (Probably by same cause) appended new row remain empty, I couldn't enter value.
Regards
--
Esgici
Viva INTERNATIONAL HMG
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: HMG_aChoice + Grid = Incremental Search in Grid Cells
Thanks Esgici.
- As the name suggests they are dummy and can be removed.
- Is it? You couldn't see the listbox?
- I could enter the value by pressing enter.
- As the name suggests they are dummy and can be removed.
- Is it? You couldn't see the listbox?
- I could enter the value by pressing enter.
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: HMG_aChoice + Grid = Incremental Search in Grid Cells
Neither in grid cell nor in listboxrathinagiri wrote: - Is it? You couldn't see the listbox?
Pressing enter erase content of cellrathinagiri wrote: - I could enter the value by pressing enter.
Regards
--
Esgici
Viva INTERNATIONAL HMG
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: HMG_aChoice + Grid = Incremental Search in Grid Cells
In that case, please use this exe file and tell me your experience!
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: HMG_aChoice + Grid = Incremental Search in Grid Cells
Hi Rathi,
Thanks a lot
Great!!!
It work fine
Excellent code
Thanks a lot
Great!!!
It work fine
Excellent code
With best regards,
Sudip
Sudip
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: HMG_aChoice + Grid = Incremental Search in Grid Cells
Sorry, nothing changedrathinagiri wrote:In that case, please use this exe file and tell me your experience!
I'm afraid that my steps may be wrong :
- Double click grid cell ( list box open, cell and item in listbox highlighted)
- Enter new value over existing one
- Press enter key
- Cell is empty
- Double click same (empty) grid cell again : ( list box open, the old value is in the list)
By the way, it seems that an old dream of Sudip coming to reality
Regards
--
Esgici
Last edited by esgici on Thu Dec 27, 2012 2:34 pm, edited 1 time in total.
Viva INTERNATIONAL HMG
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: HMG_aChoice + Grid = Incremental Search in Grid Cells
Sorry Esgici. I think you misunderstood.
You can not add anything to any list! There are only three departments and each department has three items each. Full stop. From that you have to select one. That's all.
You can not add anything to any list! There are only three departments and each department has three items each. Full stop. From that you have to select one. That's all.
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: HMG_aChoice + Grid = Incremental Search in Grid Cells
Here is a small improvement which would save some keystrokes.
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: HMG_aChoice + Grid = Incremental Search in Grid Cells
Yes, sorryrathinagiri wrote:I think you misunderstood.
While testing, I want think and behave as soon as possible like an clumsy user, I guess this is necessary and useful.rathinagiri wrote:You can not add anything to any list! There are only three departments and each department has three items each. Full stop. From that you have to select one. That's all.
After you had permitted enter somethings to anywhere to user, you haven't right to saying "you can't enter anything here!"; does I'm wrong ?
Regards
--
Esgici
Viva INTERNATIONAL HMG