You need to set CheckParams to false if you are executing trigger or stored
procedure metadata statements.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Russell Belding" <russell@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Friday, August 30, 2002 11:08 PM
Subject: [IBO] TIB_DSQL and "Unsupported Column Type:0"


> Hello IBO support
>
> Using D6 and IBO 4.2Hi.
> I am using a TIB_DSQL to execute small scripts.
>
> The following executes correctly:
>
> ALTER PROCEDURE HELLO (INTEXT VARCHAR(7))
> returns (OUT VARCHAR(7))
> AS
> begin
> out = 'hello';
> exit;
> end
>
> whereas the following produces the error message
> "Unsupported Column type :0"
>
> ALTER PROCEDURE HELLO (INTEXT VARCHAR(7))
> returns (OUT VARCHAR(7))
> AS
> begin
> out = :intext;
> exit;
> end
>
> Any suggestions?
>
> Thanks
>
> Russell Belding