[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Error message for a beginner
Hi April -
If you have defined &A.MERCHANDISE_AMT already in your code, you cannot
name another field as the same pseudonyms name. Try renaming the field
where it errored out, like &A.MERCHANDISE_AMT_TEST. Also, you have
forgotten to put '#' in your second total. You have: Let #TOTAL = TOTAL
+ &A.MERCHANDISE_AMT
Hope this helps some,
Poonam
_________________
Poonam Auluck
AMS, Inc.
703-227-5576
April
<yh266515@yahoo.c To: sqr
<sqr-users@sqrug.org>
om> cc:
Sent by: Subject: [sqr-users] Error
message for a beginner
sqr-users-admin@s
qrug.org
02/24/2003 12:00
PM
Please respond to
sqr-users
I'm learning SQR and was trying to mess around with the syxtax. These two
following procedures worked:
Begin-Procedure Test($BUSINESS_UNIT, $PO_ID, :#TOTAL)
begin-select
A.MERCHANDISE_AMT &A.MERCHANDISE_AMT
Let #TOTAL = #TOTAL + &A.MERCHANDISE_AMT
FROM SALES A
WHERE A.BUSINESS_UNIT = $BUSINESS_UNIT
AND A.PO_ID = $PO_ID
end-select
Begin-Procedure Sub-Totals
Do TEST(&A.BUSINESS_UNIT, &A.PO_ID, #TOTAL)
End-Procedure Sub-Totals
***********************************************
And the two below are my version and don't work, in fact, the message was
popped right after the first procedure. I would very much for all the help
I
can get. Thanks.
Begin-Procedure Test
Begin-Select
A.MERCHANDISE_AMT &A.MERCHANDISE_AMT
Let #TOTAL = TOTAL + &A.MERCHANDISE_AMT
FROM SALES A
WHERE A.BUSINESS_UNIT = $BUSINESS_UNIT
AND A.PO_ID = $PO_ID
End-Select
Begin-Procedure Test
Begin-Procedure Sub-Totals
Do TEST(&A.BUSINESS_UNIT, &A.PO_ID, #TOTAL)
End-Procedure Sub-Totals
**********************
Error on line 369:
(SQR 3719) Columns names and expressions must be unique or be given
unique
pseudonyms (&name).
A.MERCHANDISE_AMT &A.MERCHANDISE_AMT
Errors were found in the program file.
SQR for PeopleSoft: Program Aborting.
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
_______________________________________________
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