I'm using IBWorkbench but get the same issue with IB_SQL. Where is the
checkbox???

> -----Original Message-----
> From: Steve Landrum [mailto:steve@...]
> Sent: 22 May 2002 18:57
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Stored procedure problem
>
> This message could be comming from the tool you are using to compile

the

> procedure. In IB_ISQL there is a check box that will treat :ID as a
> local variable and expect the local variable to be declared.
>
> At 06:15 PM 5/22/02 +0100, you 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
> >
> >
> >
> >
> >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/

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