It’s that position for sure. If I change the RECREATE PROCEDURE to
CREATE PROCEDURE it works. This looks like an FB or IBO bug.

> -----Original Message-----
> From: csswa [mailto:csswa@...]
> Sent: 23 May 2002 06:33
> To: ib-support@yahoogroups.com
> Subject: [ib-support] 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
> 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
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

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

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