RE: [sqr-users] on-break

["Bencke, Gina" <GinaBencke@forestcity.net>]

Unless something is different in SQR for PeopleSoft, the syntax and
spacing of your select paragraph is important

Begin-select and column names must be flush against the left margin of
your.sqr file.  SQR commands must be indented.  No SQR Commands can be
listed between the FROM and the END-SELECT.

BEGIN-SELECT
Column1  () ...
Column2  () ...
  add 1 to #var1
  add 1 to #var2
FROM ...
WHERE ...
END-SELECT


-----Original Message-----
From: sqr-users-bounces+ginabencke=forestcity.net@sqrug.org
[mailto:sqr-users-bounces+ginabencke=forestcity.net@sqrug.org] On Behalf
Of saritha ventrapragada
Sent: Wednesday, June 09, 2004 12:29 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] on-break


Hi,
I was trying on-break command. I am using peoplesoft8.8

This is my sample .sqr file
   A.EMPLID (+2,1,6)
   B.NAME (,10,20)   ON-BREAK PRINT=CHANGE/TOP-PAGE LEVEL=1 SKIPLINES=1 
SAVE=$OLDDEPT
   A.DEPTID (,60,10)   ON-BREAK PRINT=CHANGE/TOP-PAGE LEVEL=2
SAVE=$OLDSTART 
AFTER=TOTALDEPTS
   C.DESCR    (,75,8)
   A.JOBCODE  (,95,6)
   D.DESCR    (,105,6)

ADD 1 TO #DEPTCNT
ADD 1 TO #GRANDTOT

        FROM PS_JOB A, PS_EMPLMT_SRCH_QRY A1, PS_PERSONAL_DATA B,
PS_DEPT_TBL C, 
PS_SET_CNTRL_REC C2, PS_JOBCODE_TBL D, PS_SET_CNTRL_REC D2
        WHERE C.DEPTID = A.DEPTID
..........
...........
...........


I was getting these errors.

Error on line 40:
   (SQR 3721) Bad param found on 'BEGIN-SELECT' line; Format is:
BEGIN-SELECT [DISTINCT] [-Cnn] [LOOPS=nn]
              [ON-ERROR=procedure[(arg1[,argi]...)]]
              [-DB=database]
A.EMPLID (+2,1,6)

Error on line 42:
   (SQR 3704) Missing procedure name.
B.NAME &NAME

Error on line 45:
   (SQR 5303) Invalid qualifier 'a.deptid'.  Valid qualifiers are: bold
box center code code-printer edit fill match nop on-break shade
underline wrap number money date delay foreground background url font
point-size url-target A.DEPTID &DEPTID

Error on line 48:
   (SQR 5303) Invalid qualifier 'c.descr'.  Valid qualifiers are: bold
box center code code-printer edit fill match nop on-break shade
underline wrap number money date delay foreground background url font
point-size url-target
C.DESCR    (,75,8)

Error on line 49:
   (SQR 3701) Invalid command.
A.JOBCODE  (,95,6)

Error on line 50:
   (SQR 3701) Invalid command.
D.DESCR    (,105,6)

Error on line 55:
   (SQR 3728) SQL expression not ended, perhaps missing &name. FROM
PS_JOB A, PS_EMPLMT_SRCH_QRY A1, PS_PERSONAL_DATA B, PS_DEPT_TBL C, 
PS_SET_CNTRL_REC C2, PS_JOBCODE_TBL D, PS_SET_CNTRL_REC D2
(SQR 4407) Referenced variables not defined:

  &name
  &deptid

Errors were found in the program file.

SQR for PeopleSoft: Program Aborting.


I would apprecitae if anyone could help me out in solving these problem
Thank u saritha

_________________________________________________________________
Looking to buy a house? Get informed with the Home Buying Guide from MSN

House & Home. http://coldwellbanker.msn.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