Re: [sqlite] quote() and constraints

On 3/29/06, Pam Greene <[EMAIL PROTECTED]> wrote: > On 3/29/06, jt <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I'm implementing a log procedure with triggers on my tables (following > > some ideas found in http://www.sqlite.org/cvstrac/wiki?p=UndoRedo). > > As I have more than one table, I'm

Re: [sqlite] quote() and constraints

On 3/29/06, jt <[EMAIL PROTECTED]> wrote: > > Hi, > > I'm implementing a log procedure with triggers on my tables (following > some ideas found in http://www.sqlite.org/cvstrac/wiki?p=UndoRedo). > As I have more than one table, I'm generating the relevant SQL to do the > job. > I use the quote()

[sqlite] quote() and constraints

Hi, I'm implementing a log procedure with triggers on my tables (following some ideas found in http://www.sqlite.org/cvstrac/wiki?p=UndoRedo). As I have more than one table, I'm generating the relevant SQL to do the job. I use the quote() function to quote each value of each row. The problem is