Dear D. Hipp,
Thank you very much for getting involved in this discussion. Would you
please give a concrete example of use of quote()?
Is it something wrong with doing a:
SELECT quote('AA'AA')
Thank you very much,
Iulian.
-----Original Message-----
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Monday, March 28, 2005 12:15 PM
To: Christopher Petrilli
Cc: [email protected]
Subject: Re: [sqlite] quote() function
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]>
