|Subject||Re: [IBO] SQL in IBO|
> I just tried to create a procedure something like:Why? Its either an IBO problem or an IB problem - try one and if that
> DECLARE VARIABLE dataitem VARCHAR(150);
> SELECT DATAVALUE
> FROM ATTRIBUTES
> WHERE CONTACTID = :ID
> AND ATTRIBUTEKEY = 506
> INTO :dataitem;
> 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
> I have posted this to the IB support forum too.
does not help then try the other. Please dont cross-post, many of us
attend both and dont need the duplication.
Currently I suggest investigate the responses from ib_support. This
does not look like a specifically IBO problem, although some changes
may be required to support RECREATE - I dont really know, but would
not have thought so. I presume you are trying to execute this via
IB_Script and AFAICT the only special statement parsing it does is
against SET requests.