OraFAQ Forum: Client Tools » Page Break on a field

Home » Other » Client Tools » Page Break on a field

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Page Break on a field [message #247376]

Mon, 25 June 2007 13:25

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.

Report message to a moderator

Re: Page Break on a field [message #247387 is a reply to message #247376]

Mon, 25 June 2007 14:20

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

I guess theres no such a option
but you can use set page size.

Report message to a moderator

Re: Page Break on a field [message #247390 is a reply to message #247376]

Mon, 25 June 2007 14:36

Bill B
Messages: 1971
Registered: December 2004

Senior Member

Sure, use the SKIP PAGE command on the break. For example

BREAK ON STAT_CD SKIP PAGE

Report message to a moderator

Re: Page Break on a field [message #247395 is a reply to message #247390]

Mon, 25 June 2007 14:48

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Kewl bill

Report message to a moderator

Re: Page Break on a field [message #247398 is a reply to message #247390]

Mon, 25 June 2007 14:53

Matthew Waugh
Messages: 71
Registered: October 2004

Member

This is perfect....Thanks!

Report message to a moderator

Previous Topic:	Number of db_files too high
Next Topic:	SQLPlus - How to hide the results during a SQL File exection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 17:22:06 CST 2025