If it was in a query component, it may have been looking for input
parameters. Turn off the ParamCheck behavior and see what happens.

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

----- Original Message -----
From: "DaveR" <mailings@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, May 22, 2002 5:07 PM
Subject: RE: [IBO] SQL in IBO


> I just tried to create a procedure something like:
>
> DECLARE VARIABLE dataitem VARCHAR(150);
> BEGIN
> SELECT DATAVALUE
> FROM ATTRIBUTES
> WHERE CONTACTID = :ID
> AND ATTRIBUTEKEY = 506
> INTO :dataitem;
> ...
> ...
> END
>
> but IBWworkbench reported an error at the : saying "unknown token ?".
> If I take the generated DDL and change the RECREATE to a CREATE it
> works. This maybe an IB bug or an IBO as I get the same problem using
> IB_SQL.
>
> I have posted this to the IB support forum too.