[sqlite] Re: trigger with conditions

[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 = 'something'
begin
   ...
end;

Igor Tandetnik

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