Re: [sqlite] Re: trigger and new.*

> Try this: > > CREATE TRIGGER trig_insert BEFORE INSERT ON tab > WHEN (new.champ1 LIKE "%-%") > BEGIN > insert into tab(champ1) values (strftime("%s", new.champ1)); > select RAISE(IGNORE); > END; It works perfectly. Thank you. I had tryed a similar solution, but I didn't know how to

[sqlite] Re: trigger and new.*

Charly Caulet <[EMAIL PROTECTED]> wrote: I have a table tab(UniqueID INTEGER PRIMARY KEY, champ1 TIMESTAMP). And when a date ("-MM-DD") is inserted in champ1, I would like to convert it to timestamp. I would like to modify new.champ1 value in a "BEFORE" trigger, but everything I tryed