*** 1,6 **** ! The TCL module attached implements a convenient graphical SQLite database editor. Tcl/Tk programs can make use of this module as follows: source dbedit.tcl ! dbedit::start --- 1,53 ---- ! {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: source dbedit.tcl ! dbedit::start db ! ! The "db" argument to "dbedit::start" specifies the SQLite database ! object that is loaded into the editor. ! ! 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} ! If you click on any of the column labels, a pop-up menu appears ! with the options "Search", "Edit", and "Index". If you select ! "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. ! {clear} ! ---- ! Sometimes you might have a column that contains more data ! than will comfortably fit in the space provided. An example ! of this is the "blob" table of the ExperimentalMailUserAgent ! database - the table that contains the complete text of ! email messages. As you can see, the text does not all fit ! in the "data" column. ! {clear} ! {rightimage: dbe6.gif} ! 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} ! ---- ! {rightimage: dbe8.gif} ! Type some text into the "Pattern" entry box at the top then ! select the "Search" option on a column label to advance to ! the new row that contains the pattern text.