> 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 st
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 doesn't
2 matches
Mail list logo