SQLite CVSTrac

*** 1,4 ****
- {rightimage: edit2.gif}
  **The Problem**
  
  Suppose you have a table with a TEXT field that
--- 1,3 ----
***************
*** 15,27 ****
  tedious and error-prone.  It would be better if you could just edit the
  text that was in the field using a text editor.
  
  **A Solution: The edit() Function**
  
  If you have the ConsoleForTclTk available, you can do this using the
  "edit()" SQL function that the console builds in.  Consider the example
  shown in the image on the top-right corner of this page.  The database
  being edited is the CVSTrac database for SQLite.  Suppose we want to change
! the check-in message for check-in [2732].  We could simply type:
  
     UPDATE chng SET message = edit(message) WHERE cn=2732;
  
--- 14,28 ----
  tedious and error-prone.  It would be better if you could just edit the
  text that was in the field using a text editor.
  
+ {rightimage: edit2.gif}
  **A Solution: The edit() Function**
  
  If you have the ConsoleForTclTk available, you can do this using the
  "edit()" SQL function that the console builds in.  Consider the example
  shown in the image on the top-right corner of this page.  The database
  being edited is the CVSTrac database for SQLite.  Suppose we want to change
! the check-in message for check-in [2732].
! {clear} We could simply type:
  
     UPDATE chng SET message = edit(message) WHERE cn=2732;

sqlite - Interactive Text Field Editing