At 02:57 PM 9/05/2005 +0000, you wrote:

>I'm trying to modify a trigger on one of my tables and I keep getting
>the message "Unsupported Column Type: 0".
>
>What does this mean and how do I fix it? Please tell me it's
>something I'm doing wrong and it's easliy fixed.

Well, you do have some ambiguities between the main query and the subquery,
but I suspect the cause of the error you are seeing is that you are using
IB_SQL's DSQL interface to submit this request and you have forgotten to
uncheck the Params checkbox.

./heLen

>Thanks,
> Ryan
>
>The original trigger code is this:
>...
>as
>declare variable memid integer;
>begin
> for
> select memberid
> from organizationmember
> where organizationid = new.organizationid and
> memberwantsemails = 1 and
> memberstatus >= 1 and
> memberid not in (select memberid
> from emailjobstats
> where emailjobid = new.emailjobid)
> into :memid
> do
> begin
> insert into emailjobstats (emailjobid, memberid)
> values (new.emailjobid, :memid);
> end
>end
>
>
>The new code I'm trying to compile is this:
>.....
>as
>declare variable memid integer;
>DECLARE VARIABLE wisjot smallint;
>DECLARE VARIABLE wwantsjot smallint;
>BEGIN
> SELECT isjot
> FROM emailjobs
> WHERE emailjobid = new.emailjobid
> INTO :wisjot;
>
> for
> select memberid,
> memberwantsjot
> from organizationmember
> where organizationid = new.organizationid and
> memberwantsemails = 1 and
> memberstatus >= 1 and
> memberid not in (select memberid
> from emailjobstats
> where emailjobid = new.emailjobid)
> into :memid, :wwantsjot
> do
> BEGIN
> IF (((wisjot=1) and (wwantsjot=1)) or (wisjot=0)) then
> begin
> INSERT into emailjobstats (emailjobid, memberid)
> values (new.emailjobid, :memid);
> end
> end
>END
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>