On Mon, 2005-03-28 at 12:03 -0500, Christopher Petrilli wrote: > I suspect it was intended to be used like this: > > select quote(columname) from table; >
Chris's suspicions are correct. quote() is especially useful within triggers where the trigger generates SQL code that will undo the change the invoked the trigger. This can be used to generate a general-purpose undo/redo mechanism in a program that uses sqlite as its primary data structure. -- D. Richard Hipp <[EMAIL PROTECTED]>