Re: [sqlite] Re: trigger with conditions

2007-02-26 Thread anis chaaba
Thx :) 2007/2/26, Igor Tandetnik <[EMAIL PROTECTED]>: anis chaaba <[EMAIL PROTECTED]> wrote: > Can you tell how can i trigger with conditions such as: > create trigger foo > begin > if (NEW.VALUE = 'something') > insert into tables values.. > endif > END;

[sqlite] Re: trigger with conditions

2007-02-26 Thread Igor Tandetnik
anis chaaba <[EMAIL PROTECTED]> wrote: Can you tell how can i trigger with conditions such as: create trigger foo begin if (NEW.VALUE = 'something') insert into tables values.. endif END; http://sqlite.org/lang_createtrigger.html create trigger foo after update on someTable when new.value