[Date Prev][Date Next][Thread Prev][Thread Next]
[SQRUG Home Page]
[sqr-users] BEFORE-PAGE, AFTER-PAGE procedures??
I have a couple of SQR jobs that run fine most of the times, but a few
instances fail, and I get the following error in the Job factory Log:
>>(SQR 5400) Second page write attempted while writing current page.
>>Check BEFORE-PAGE, AFTER-PAGE procedures.
Yeah the jobs are a little funky in the sense that the header that comes on
the first page is dynamic, so I calculate the position of first line based
on the number of lines used by the header dynamically... Something like
Let #HeaderSpace = #HeaderSpace * 10 !Header Space is the number
of lines taken up by the header (only on page one)
Add 10 to #HeaderSpace !To make sure that
the variable headerspace is > 0 for relative positioning
enough room on the page, printing will start 10 points below the header
If #HeaderSpace >= (#sqr-max-lines) !If the header takes up the
entire page, start printing query results on page two
Position (+#HeaderSpace ) !Else set print
position at #HeaderSpace
Any clue of what might be happening here?
Any help will be greatly appreciated.
Dev Rishi Sahani
FESCo DB Systems
sqr-users mailing list