On Thu, 2005-08-18 at 22:26 +0200, Mark de Vries wrote: > create table foo ( > value TEXT, > date_create TEXT, > date_lch TEXT > ); > > Now, whenever I insert into this table I want to set date_create to > CURRENT_TIMESTAMP. > > Whenever I update a row I want date_lch (lch=last change) to be set to > CURRENT_TIMESTAMP. (Changes to the date_create col should be (silently) > 'ignored'. >
create trigger r1 after insert on foo begin update foo set date_create=current_timestamp where rowid=new.rowid; end; create trigger r2 after update on foo begin update foo set date_lch=current_timestamp where rowid=new.rowid; end; -- D. Richard Hipp <[EMAIL PROTECTED]>