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.

Jason

----- Original Message -----
From: "jmartine3" <joe@...>
To: <IBObjects@yahoogroups.com>
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):
>
[snip]
>
> 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
>