[sqr-users] RE: On-break (lowest level identical while level above breaks)

["White, Denise" <DEWhite@vicr.com>]

Thanks, Don!  You learn something new every day!  A bit of experimentation 
revealed that using break procedures (before, after) requires a begin-select, 
while just using skiplines did not.  As I said, I had never seen on-break used 
on an array before, hence my ignorance.

BTW, I would be an 'amie'!  Other than getting my gender wrong, your French was 
fine!

Denise M. White
Sr. Software Engineer
Vicor 
--__--__--

Message: 4
Date: Fri, 23 Jan 2004 11:43:30 -0500 (EST)
From: Don Mellen <donm@ontko.com>
To: "SQR Users Group (E-mail)" <sqr-users@sqrug.org>
Subject: Re: [sqr-users] RE: On-break (lowest level identical while level above 
breaks)
Reply-To: sqr-users@sqrug.org

Au contraire, mon ami (sorry for the poor french spelling).

While the construct does look good and should be working, and I
agree it's probably a problem in the break procedures... The begin-select
is most necessary.  On-break is tied to begin-select for some of it's
logic (and won't even compile outside of a begin-select in some versions).
Having a one row select (from dual for most oracle users) allows the
on-break logic to be used for arrays or from reading a flat file.  The
only caveat being that your array or file needs to already be sorted in
the order you need.

On Fri, 23 Jan 2004, White, Denise wrote:

> 
> BTW, I was wondering as I read the beginning of your message how you
> could possibly be selecting data from an array with a begin-select.  I
> am not sure if you abbreviated the logic when you wrote your message,
> but there is really no reason at all for you to have that begin-select
> procedure, as you are not actually selecting anything.  You could do
> your array logic within a regular begin-procedure paragraph.
> 
> Denise M. White
> Sr. Software Engineer
> Vicor 

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