Re: [sqlite] BEFORE INSERT TRIGGER

ins a double quote in it, perhaps? In fact it's not double quote, it should be extra endline character I think. Pavel On Thu, Jun 10, 2010 at 8:29 AM, Igor Tandetnik wrote: > Tareq Khan wrote: >> Thanks for the reply.  Yes I am aware of that... I have just updated to the >&g

Re: [sqlite] BEFORE INSERT TRIGGER

- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: 10 June 2010 13:13 To: sqlite-users@sqlite.org Subject: Re: [sqlite] BEFORE INSERT TRIGGER Tareq Khan wrote: > I have looked through the list with regards to my issue and there

[sqlite] BEFORE INSERT TRIGGER

Hi I have looked through the list with regards to my issue and there are several entries that say that the following is correct for a BEFORE INSERT trigger: CREATE TRIGGER AlbumSectionInsertTrigger BEFORE INSERT ON AlbumSection FOR EACH ROW BEGIN SELECT CASE WHEN (