I am attempting to crete a trigger that fills a field with "unknown" if a
update leaves it empty.
the trigger I tried is shown below, but it does not seem to work. Any ideas
what I am doing wrong?
Thanks - JZ
$query = "CREATE TRIGGER update_editby AFTER INSERT ON employee
BEGIN
UPDATE employee SET editby = 'unknown' WHERE editby = '' AND rowid =
new.rowid;
END;
";
--
View this message in context:
http://old.nabble.com/Need-trigger-tp32966496p32966496.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
