*** 1,6 **** {rightimage: dbe1.gif} ! The TCL module attached (see the "Attachments" section below for ! a link to the source code) implements a convenient graphical SQLite database editor. Tcl/Tk programs can make use of this module as follows: --- 1,6 ---- {rightimage: dbe1.gif} ! The TCL module ! {link: /cvstrac/attach_get/283/dbedit.tcl attached below} implements a convenient graphical SQLite database editor. Tcl/Tk programs can make use of this module as follows: *************** *** 13,23 **** The screenshots on this page show the dbedit module being used on the ExperiementalMailUserAgent. {clear} ---- {rightimage: dbe2.gif} ! Select the table to show in the editor from the optionmenu in the upper left-hand corner of the editor. {clear} ---- {rightimage: dbe3.gif} --- 13,39 ---- The screenshots on this page show the dbedit module being used on the ExperiementalMailUserAgent. + + This widget is not the sort of thing that one should + expose it to an end user in a shrink-wrapped program. But it is + very handy as a debugging and development aid in Tcl/Tk programs + that make use of SQLite. One useful strategy is to omit the menu option that + launches this widget by default, so that end users cannot see or + use it, but provide an + {link: http://en.wikipedia.org/wiki/Easter_egg easter-egg} that + inserts the menu entries for launching this widget (and possibly + other debugging widgets such as ConsoleForTclTk). {clear} ---- {rightimage: dbe2.gif} ! Select the table to be edited or viewed from the optionmenu in the upper left-hand corner of the editor. + + You can cause a particular table to be in view when the widget + is first launched using the -table option. For example. + + dbedit::start db -table msg + {clear} ---- {rightimage: dbe3.gif} *************** *** 26,31 **** --- 42,48 ---- "Index" then list of all distinct values for that column appears at the left. {clear} + ---- {rightimage: dbe4.gif} Click on any of the values in the "index" and the next entry in the table with that value appears at the right. *************** *** 42,48 **** For more convenient editing, choose the "Edit" option from the "data" column pop-up menu... {clear} ! {rightimage: dbe7.gif} A multi-line text editor appears that makes editing large fields much more convenient. {clear} --- 59,66 ---- For more convenient editing, choose the "Edit" option from the "data" column pop-up menu... {clear} ! ---- ! {rightimage: dbe7b.gif} A multi-line text editor appears that makes editing large fields much more convenient. {clear}