Hello
I tried to update 2 colums of my recently added row in my table sites.
The colums are createTime and updateTime, but sqlite only sets
updateTime, the other colum stay plain. Sqlite doesn't complain about
anything so I don't know whats wron.
CREATE TRIGGER insert_sites_createTime AFTER INSERT ON sites
BEGIN
UPDATE sites SET createTime = DATETIME('NOW') AND updateTime =
DATETIME('NOW')
WHERE rowid = new.rowid;
END;
best regards,
Michael Grassl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
