It looks like to me that CREATE TRIGGER IF NOT EXISTS is recognized by sqlite, but I get the following from the command line:
sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, value TEXT, timestamp DATE);sqlite> CREATE TRIGGER IF NOT EXISTS foo_log AFTER INSERT ON foo BEGIN INSERT INTO foo (timestamp) VALUES (DATETIME('NOW')); END; SQL error: near "NOT": syntax error sqlite> CREATE TRIGGER foo_log AFTER INSERT ON foo BEGIN INSERT INTO foo (timestamp) VALUES (DATETIME('NOW')); END; sqlite> Is this expected? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users