Not sure why you are trying to do something like that. One technique which seems to be quite common, and that I use extensively, is to present a scrollable read only grid of pertinent data fields. with a "VCR" button set for control. The user can press the buttons for Insert, Delete, or Edit for a selected record. Double clicking the highlighted item opens a detailed view window. (The edit form in read only mode.)
I don't see a whole lot of advantage of presenting a scrollable editable grid (Very easily done, code wise, in Delphi) as most all records I work with greatly exceed the capabilities of a single GUI line length. Actually I think a third party Delphi Grid Component vendor I use may have the capability to do what you describe, although I have no interest is finding out how far I can "stretch" their grid in that direction. Anyway that's enough off topic from here. Fred > -----Original Message----- > From: David Bicking [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 05, 2006 8:43 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] UI framework for sqlite > > > 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 >
