[sqlite] Re: help in triggers(calling functions)

[drh]

"Chethana, Rao \(IE10\)" <[EMAIL PROTECTED]> wrote:
> Hello!
> 
>  
> 
> How do I call functions(user defined) or  stored procedures from
> triggers in sqlite?
> 
> For example,  how do I do this in sqlite?
> 
>                                   CREATE TRIGGER TrgIns_PTable AFTER
> INSERT ON PTable FOR EACH ROW EXECUTE PROCEDURE PP_InsPTable(); 
> 

CREATE TRIGGER TrgIns_PTable AFTER INSERT ON PTable
FOR EACH ROW
  SELECT PP_InsPTable();
END;

--
D. Richard Hipp   <[EMAIL PROTECTED]>