Re: [sqlite] modifying insert/updat data in triggers (was: manipulating new.? in triggers)

> 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'. If you feel you cannot trust applications to

Re: [sqlite] modifying insert/updat data in triggers (was: manipulating new.? in triggers)

> 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]> > cre

Re: [sqlite] modifying insert/updat data in triggers (was: manipulating new.? in triggers)

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 b

Re: [sqlite] modifying insert/updat data in triggers (was: manipulating new.? in triggers)

On Thu, 18 Aug 2005, Kurt Welgehausen wrote: > > Is it possible to change the values of certain rows that > > are inserted into the database? ... > > I think everything you need is explained at > > . Yeah, I've read it. > If you don't understand