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

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

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