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 > > <http://www.sqlite.org/lang_createtrigger.html>.
Yeah, I've read it. > If you don't understand how to get the current date in > SQLite, look at the wiki page. > This too. But I still don't know how to do what I want to do. Perhaps I need to explain with a litle more detail what I mean. Consider the following table. 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'. This is exactly what the oracle trigger from my first mail does. Basically any user specified value for these columns is always ignored as the values to be inserted are modified by the trigger before the insert happens. Can someone tell me if someting simmilar is or isn't possible with triggers sqlite? And if it is possible an example of how to do it? If it isn't possible I'll just push this logic to the application level. No real biggy. It's just that (for larger databases) I always try to push as many 'business rules' & logic into the database. This makes the data better protected from application level errors/bug and saves (duplicate) code in the apps accessing the database. Regards, Mark
