11-20-2008, 12:37 AM
Hi Ken, Kehmu, TheVig, others...(of course, Gintaras!)
I am trying to get a grid control for an excel spreadsheet that I currently use as a way to keep track of interesting medical cases. I fill out new entries via a GUI-Hack of Excel in QMscript. know that there are Excel functions now in QM, but I need to save the final document as an Excel web page for the final user interface so that the user has a very streamlined sortable filterable interface. I use intrinsic Qm excel function to fill out the table but then do a GUIhack to get it to save as a the proper html file type instead of the usual xls. Anyway, I hang the html in a Toolbar Webbrowser). The downside of this approach is the html version is not editable and it is a gui-hack which I hide behind the Curtain function.
Anyway, I wrote a version of the Grid in QM_Grid which displayed nicely but is not sortable. Ideally, I would like to filter and search on it, but sorting columns is probably the most important.
I have seen some of the many shareware MySqlLite options on the link that Gintaras provided: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
For example, something like these screencaptures: http://sqlitebrowser.sourceforge.net/screenshots.html
There are so many, I am kind of intimidated to jump in. Does anyone have a good recommendation for how to go at this: ScGrid, SqlLite, something else. Preferable one with an easy interface or sample scripts I can reverse engineer to my pretty simple needs.
Thanks for any advice from anyone.
Stuart
I am trying to get a grid control for an excel spreadsheet that I currently use as a way to keep track of interesting medical cases. I fill out new entries via a GUI-Hack of Excel in QMscript. know that there are Excel functions now in QM, but I need to save the final document as an Excel web page for the final user interface so that the user has a very streamlined sortable filterable interface. I use intrinsic Qm excel function to fill out the table but then do a GUIhack to get it to save as a the proper html file type instead of the usual xls. Anyway, I hang the html in a Toolbar Webbrowser). The downside of this approach is the html version is not editable and it is a gui-hack which I hide behind the Curtain function.
Anyway, I wrote a version of the Grid in QM_Grid which displayed nicely but is not sortable. Ideally, I would like to filter and search on it, but sorting columns is probably the most important.
I have seen some of the many shareware MySqlLite options on the link that Gintaras provided: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
For example, something like these screencaptures: http://sqlitebrowser.sourceforge.net/screenshots.html
There are so many, I am kind of intimidated to jump in. Does anyone have a good recommendation for how to go at this: ScGrid, SqlLite, something else. Preferable one with an easy interface or sample scripts I can reverse engineer to my pretty simple needs.
Thanks for any advice from anyone.
Stuart