Re: [sqlite] Trouble with Trigger

Dennis: Thanks for unveil (to me) that interesting page. Greetings A. J. Millan - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: Sent: Tuesday, November 14, 2006 12:57 AM Subject: Re: [sqlite] Trouble with Trigger > A.J.Millan wrote: > > I

Re: [sqlite] Trouble with Trigger

A.J.Millan wrote: I want know if is possible to do a DELETE, INSERT or UPDATE statement from inside a TRIGGER. Any idea in this respect, or alternative, will be grateful See the documentation at http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers for a complete description of such tr

[sqlite] Trouble with Trigger

I want know if is possible to do a DELETE, INSERT or UPDATE statement from inside a TRIGGER. Let's say: CREATE TABLE tableA ( Id INTEGER, ... ); CREATE TABLE tableB ( Ref INTEGER, ... ); CREATE TRIGGER DeleteReferences BEFORE DELETE ON tableA BEGIN SELECT CASE WHEN (SELECT count(*) F