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.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.361 / Virus Database: 199 - Release Date: 07/05/2002