> 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.

Why? Its either an IBO problem or an IB problem - try one and if that
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.

--
Geoff Worboys
Telesis Computing