Randle
Per the SQR manual (ver 3.X and 4.X), Next-Listing causes a new vertical offset in the current page to begin.
I tested, and sure enough, outside a Select statement, SQR handled the Next-Listing as expected. SQR evaluated the remaining lines on the current page and determined whether or not it had room to continue on that page. When it had room, it printed my data on the same page. When there wasn't enough room, it started a new page.
Hope this helps
Art DiRamio
Open Solutions Inc. (OSI)
300 Winding Brook Drive
Glastonbury CT 06033
adiramio@opensolutions.com
PS: On the Year 2000 stuff, it sounds like SQR is fine. If you are worried about the end-users typing in invalid dates, don't allow them to. I agree that this approach takes a little more code, but I like to think it is time well spent to ensure that everyone is on the same page. . .
----------
From: Randle Boyd[SMTP:rboyd@RUAN.COM]
Sent: Tuesday, October 07, 1997 10:41 AM
To: Multiple recipients of list SQR-USERS
Subject: NEXT-LISTING
SQR v.3 Oracle v.7
I am putting a signature block (requiring six lines) at the bottom of
the last page of a report. The problem that I am running into is that
sometimes there are less than six lines left on the page. This results
in the signatur block being slit across two pages. Am I correct to
assume that the 'NEXT-LISTING NEED = 6' command can only be used within
a select statement? If so, is there a similar command I could use for
printing lines that aren't the result of a select statement?
Any help is greatly apprediated!
Thanks,
Randle