[sqlite] conditional code in trigger

[chetana bhargav]

Hi ,

I have two seperate triggers like,

CREATE TRIGGER cnt1
  AFTER INSERT
  ON tbl1
  WHEN (new.Id =1 and new.priority > 2 )
BEGIN
  update cnt set Critical = (SELECT Critical from msgs_cnt where Id=1) + 1 
where Id=1;
 end;

CREATE TRIGGER cnt2
  AFTER INSERT
  ON tbl1
  WHEN (new.Id =1 and new.priority < 2 )
BEGIN
  update cnt set Normal = (SELECT Normal from cnt where Id=1) + 1 where Id=1;
 end;

I am trying to combine these two trigs into one using if..else condition is it 
possible.

When i try it its giving me error. I tried the following way

CREATE TRIGGER cnt1
  AFTER INSERT
  ON tbl1
  WHEN (new.Id =1 )
BEGIN
 if( new.priority > 2)
  update cnt set Critical = (SELECT Critical from msgs_cnt where Id=1) + 1 
where Id=1;
else 
  update cnt set Normal = (SELECT Normal from cnt where Id=1) + 1 where Id=1;
end;


Is it possible to do some thing like this or it's too much of C.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com