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 that " SELECT quote('foo')!='foo' ": when I tried to
load the log table in another database, I get "SQL error; constraint
failed" on every row that has a CHECK constraint.
The quick solution is to add quote() around each value in the CHECK statement.
Is there another way to do it?
Why is " SELECT quote('foo')!='foo' "?
config: sqlite 3.3.4
--
jt
