> INTO mailing_address_indicator;

That should have the : prefix (:mailing_address_indicator).

Are you sure that the line number of the error 'token unknown' is the
same as line number for the 'unknown column' error? Perhaps 'token
unknown' is flagging a second error in the script unrelated to the
INTO line??

Regards,
Andrew Ferguson
-- Building confidence through the miracle of self-delusion.

--- In ib-support@y..., "DaveR" <mailings@b...> wrote:
> I'm trying to create a procedure, part of which is shown below, but
I
> cannot get it to compile. It throws an error on "INTO
> mailing_address_indicator;" complaining that
mailing_address_indicator
> is an unknown column if I don't prefix it with a : or "token
unknown ?"
> if I do.
>
> I must be doing something stupid but I cannot see what. Any ideas?
>
> RECREATE PROCEDURE TEST (ID Integer) returns (TITLE VarChar(150))
> AS
> DECLARE VARIABLE mailing_address_indicator VARCHAR(150);
> BEGIN
> SELECT DATAVALUE
> FROM ATTRIBUTES
> WHERE CONTACTID = :ID
> AND ATTRIBUTEKEY = 506 /* Address Indicator */
> INTO mailing_address_indicator;
> ...
> ...
> END
>
> ---
> 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