|Subject||Re: Stored procedure problem|
> 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
-- 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
> cannot get it to compile. It throws an error on "INTO
> mailing_address_indicator;" complaining that
> is an unknown column if I don't prefix it with a : or "token
> 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))
> DECLARE VARIABLE mailing_address_indicator VARCHAR(150);
> SELECT DATAVALUE
> FROM ATTRIBUTES
> WHERE CONTACTID = :ID
> AND ATTRIBUTEKEY = 506 /* Address Indicator */
> INTO mailing_address_indicator;
> 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