Other DBMS support the following construct in a trigger: CREATE TRIGGER name BEFORE UPDATE ON table FOR EACH ROW BEGIN SET NEW.column = anyvalue END;
In SQLite, the NEW record appearently is read-only. Support for changeable NEW records would however be graceful as it automatically prevents an infinite loop (recursive trigger) that can will more or less automatically occur otherwise when working with additional UPDATE-statements. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
