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

["Prasanna Menta" <pmenta@umuc.edu>]

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