SQLite CVSTrac

*** 1,3 ****
--- 1,4 ----
+ {rightimage: edit2.gif}
  **The Problem**
  
  Suppose you have a table with a TEXT field that
***************
*** 8,20 ****
  Using the UPDATE command you would have to say
  something like this:
  
!   UPDATE table SET field='new value' WHERE rowid=...;
  
  This requires that the entire revised text be retyped.  That is long and
  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
--- 9,22 ----
  Using the UPDATE command you would have to say
  something like this:
  
!   UPDATE table
!      SET field='new value'
!    WHERE rowid=...;
  
  This requires that the entire revised text be retyped.  That is long and
  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
***************
*** 22,28 ****
  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;
  
--- 24,30 ----
  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;

sqlite - Interactive Text Field Editing