RE: [sqr-users] on-break

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

The columns (like A.EMPLID) should not be indented.  The SQR commands (like
ADD) should be indented.

-----Original Message-----
From: saritha ventrapragada [mailto:sperumudi@hotmail.com]
Sent: Wednesday, June 09, 2004 9:29 AM
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