Subject Re: [IBO] "Unsupported Column Type"???
Author Jason Wharton
Use the ExecuteImmediate() method instead of the SQL property. It is MUCH
faster since you don't have to do a prepare. The reason it is having a
hangup is because I am processing the procedures internal parameters as
statement parameters. Set the ParamCheck property to false and it will work
with what you are doing, though it will be slower than what I recommend.


----- Original Message -----
From: "jmartine3" <joe@...>
To: <>
Sent: Tuesday, June 03, 2003 11:53 AM
Subject: [IBO] "Unsupported Column Type"???

> I'm attempting to create a stored procedure. I've already tested the
> SP with DSQL (using IB_SQL, formatted with different whitespace), and
> it works fine.
> However, when I try to create it in my code (to add it to the
> database), I get the following exception:
> Unsupported Column Type: 0
> Here is my code (Note: ScratchQuery2 is a TIBOQuery):
> What am I doing wrong???
> Is the problem with my C++ code, or with the SP? As I said, I've
> already tested this SP. Are SP's picky about whitespace and formatting?
> -Joe