RE: [sqr-users] on-break

["the dragon" <ceprn@hotmail.com>]

Saritha,

Send us the whole procedure, but what I suspect, from looking below is that 
your column names for those columns selected below need to be in column 1 
and the everything between the last column selected and the from must be 
indented and out of column one.

hope this helps

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)


----Original Message Follows----

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



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