Home » SQL & PL/SQL » Client Tools » Page Break on a field
Page Break on a field [message #247376] Mon, 25 June 2007 13:25 Go to next message
Matthew Waugh
Messages: 71
Registered: October 2004
Member
Is there a way to have SQL+ create a pagebreak every time a field changes? Rather than have a pagebreak every 10 records, I'd like a new page with each change in a certain field...

Thanks in advance.
Re: Page Break on a field [message #247387 is a reply to message #247376] Mon, 25 June 2007 14:20 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I guess theres no such a option
but you can use set page size.
Re: Page Break on a field [message #247390 is a reply to message #247376] Mon, 25 June 2007 14:36 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Sure, use the SKIP PAGE command on the break. For example

BREAK ON STAT_CD SKIP PAGE
Re: Page Break on a field [message #247395 is a reply to message #247390] Mon, 25 June 2007 14:48 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Kewl bill Wink
Re: Page Break on a field [message #247398 is a reply to message #247390] Mon, 25 June 2007 14:53 Go to previous message
Matthew Waugh
Messages: 71
Registered: October 2004
Member
This is perfect....Thanks!
Previous Topic: Number of db_files too high
Next Topic: SQLPlus - How to hide the results during a SQL File exection
Goto Forum:
  


Current Time: Tue Dec 06 10:23:13 CST 2016

Total time taken to generate the page: 0.07416 seconds