Laurent LAVAUD <l.lavaud-F9DrG26JU6dWk0Htik3J/[EMAIL PROTECTED]> wrote:
I have a problem to get < RAISE > function working.
When the trigger is triggered by an insert, i only want to execute
the < update > and skip the first insert.
create trigger checkdrop before INSERT on blocked when (select
count(*) from blocked where id=new.id) > 0
BEGIN
when
What is this 'when' doing here?
update blocked set hits = hits + 1 where id = new.id;
RAISE (IGNORE)
RAISE is a function, not a statement. Make it
select RAISE(IGNORE);
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------