Hi David, if you're looking for a truly portable tool, you should consider Tcl/Tk. SQLite has a builtin interface to Tcl, Starkits are portable between many OSes without any code change and the tktable widget ot tablelist should be what you are looking for to present your data.
Visit http://wiki.tcl.tk/2633 (sqlite), http://wiki.tcl.tk/1877 (tktable) and http://wiki.tcl.tk/5527 (tablelist) for more info. For starkits see http://www.equi4.com/starkit.html Good luck for your project and happy Tcl'ing Ulrich On Wednesday 05 April 2006 15:42, David Bicking wrote: > This is probably off-topic for this list, so let me apologize in advance > if it is. I don't have a probably in using sqlite itslef, but in rather > how to use a UI to present the info to the user. I am not neccesarily > asking for how to advice here, but rather pointers on where I can find > such advice. > > I have written applications that will grab a record from an sqlite > table, and insert the values in pre-existing text boxes, which the user > can then change, finally clicking a save button, which sends the changed > data back to sqlite. > > I have also written applications that will select multiple records, and > dump that data as a printed report on paper. > > What I don't know how to do (without specialized tools) is to grab > multiple records and present them in editable fashion to the user, > keeping track of changes so thy can be written back. I am looking for > something like a datasheet view or continuous form on MS Access. > > I have been advised to just place enough edits boxes for five or so > records, then fill in the first five, then give the user "Next Five" and > "Previous Five" buttons to click. But I would rather a solution in which > the user can scroll down to see all the records, (within reason). > > I also want to do this with the least overhead and the most portable way > possible. My target audience is like my brother in laws business: they > have a few non-networked PC's with a mixture of versions of windows. My > second audience is my own home network of PC's running windows and > linux. > > This, I believe, leaves out any tool that requires KDE or Gnome or > anything big and bloated. While I consider GTK to be big and bloated, I > guess that is the upper limit that I want to consider. > > My language of choice is Basic, but do program in C, and have programmed > in C++. > > So I am looking for links to tutorials or how-tos, or even the right > string of text to use on google to point me in the right direction. > > Any advice is appreciated. > Thanks, > David
