This is an extension request that in theory shouldn't be too hard to do (I should imagine anyway), but is immensely important.
I'd be ok to pay a modest sum towards your efforts, which would obviously need to be considered privately, but some discussion over features and feasability on this thread are quite welcome. The extension would be very useful, so it would naturally get released freely for all.
It's basically just a frontend for the windows grid-list display - the one you'll find used in almost everything, from Windows Explorer to any kind of accounts package. You'll see a perfect example if you open a folder in XP and select the 'Details' view.
It should be able to use all the main features of the windows grid-list, such as named columns, and of course the ability to click on a column to select and sort it up or down, just as with any folder (so you could arrange your data set by date, filesize, alphabetic, or any value).
It should be possible to show or hide certain columns (so if needs be you can use events to sort them using a column that isn't displayed).
It would also need to be as fast as possible in loading large data sets. Obviously you may be limited by the actual Windows code (I'm only asking for a frontend here, to give us access to this nifty Windows control), but anything you can do to give it an edge would be appreciated.
An option to have the cells set by row and column number is a must, so it can be populated within a fastloop if needs be, but also the ability to load a CSV or Tab-Delimited-File would be good.
Other non-essential but preferred features might include:
- Option to determine using events what kind of width each column will have.
- An expression to return the row and cell number of wherever the mouse happens to be hovering at the time.
- Option for multiselect may be useful.
- Anything else you may think useful.
My number one reason for requesting this is that there's little standard way to display Database results in MMF. Developer has the grid object, but not being a standard window control, it lacks the intuitive harmony with other software (you get used to what you can and can't do with the win control, like sorting, etc).
I think the community would really benefit from this, and I know I certainly would.