Hi,
There was some recent discussion about timestamp triggers, something I
have been trying to get working on my own. Specifically, I have two
fields, insert_ts and last_upd_ts, which I would like to be the insert
time and last update time, respectively. However, when I try to write
a trigger to populate these fields, only last_upd_ts gets populated.
I have tried two versions of the trigger:
CREATE TRIGGER task_list_1
AFTER INSERT ON task_list
BEGIN
UPDATE task_list
SET insert_ts = datetime('now','localtime'),
last_upd_ts = datetime('now','localtime')
WHERE task_id = NEW.task_id;
END;
and, thinking that update might only be allowed to populate one column
at a time,
CREATE TRIGGER task_list_1
AFTER INSERT ON task_list
BEGIN
UPDATE task_list SET insert_ts = datetime('now','localtime')
WHERE
task_id = NEW.task_id;
UPDATE task_list SET last_upd_ts = datetime('now','localtime')
WHERE
task_id = NEW.task_id;
END;
Do I have to write a seperate trigger for each column that I want to
update? That seems inefficient to me, so hopefully there is another
way.
Thanks for any help,
Bill
