Hallo,
I want to have a column 'last_changed' in a table, which shows the date
of the last change (inser or update) of the row. I though the default
value in the CREATE TABLE was a good idea:
CREATE TABLE (
id integer,
name text,
last_changed text default current_date
)
That works for INSERTs, but seems not to work for UPDATEs. Is that
right? What to do?
Ulrich
--
Ulrich Goebel
Paracelsusstr. 120, 53177 Bonn
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
