Re: [sqlite] manipulating new.? in triggers

2005-08-18 Thread Kurt Welgehausen
> Is it possible to change the values of certain rows that > are inserted into the database? ... I think everything you need is explained at . If you don't understand how to get the current date in SQLite, look at the wiki page. Regards

[sqlite] manipulating new.? in triggers

2005-08-18 Thread Mark de Vries
Hi, Is it possible to change the values of certain rows that are inserted into the database? Let say I have a col that records the date the row it was entered. On insert I want to set it, and on update I want to make sure it's never altered. Also I have a col that records the date it was last