RE: [sqr-users] Need another set of eyes.

[David Arthur <david.arthur@amec.com>]

Try indenting your let statement.

-----Original Message-----
From: M S Bugge [mailto:msbugge@hotmail.com]
Sent: Monday, April 14, 2003 3:32 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Need another set of eyes.


Hi Prasanna,
I have not used it any where just this.
Thanks

----- Original Message -----
From: "Prasanna Menta" <pmenta@umuc.edu>
To: <sqr-users@sqrug.org>
Sent: Monday, April 14, 2003 5:24 PM
Subject: Re: [sqr-users] Need another set of eyes.


> You using the same alias type in a different procedure, just change the
> alias from b.analysis_type to bb.analysis_type, it should work
>
> Hope this helps
> Prasanna
>
> M S Bugge wrote:
> >
> > BlankThis is strange why am i getting this error: Somebody please assist
me with another set of eyes.
> >
> > begin-procedure  validate-ledger-type
> > #debugf show 'validate-ledger-type'
> >
> > begin-select
> >
> > b.ANALYSIS_TYPE
> >
> > let $atype = &b.ANALYSIS_TYPE
> >
> > from PS_RR_MP_PC_XREF b
> > where b.RR_MP_LT = $ledger_type
> >
> > end-select
> >
> > end-procedure ! validate-ledger-type
> >
> > Error on line 332:
> >    (SQR 3719) Columns names and expressions must be unique or be given
unique ps
> > eudonyms (&name).
> > let $atype = &b.ANALYSIS_TYPE
> >
> > Errors were found in the program file.
> >
> > Thanks in advance
> >
> > Bugge
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

The information contained in this e-mail is intended only for the individual or 
entity
to whom it is addressed.  Its contents (including any attachments) are 
confidential and
may contain privileged information.  If you are not an intended recipient you 
must not
use, disclose, disseminate, copy or print its contents.  If you receive this 
e-mail in
error, please notify the sender by reply e-mail and delete and destroy the 
message.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users