Re: [sqlite] Re: trigger with conditions

[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;

http://sqlite.org/lang_createtrigger.html

create trigger foo after update on someTable
when new.value = 'something'
begin
   ...
end;

Igor Tandetnik


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]

-----------------------------------------------------------------------------