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

["Brandt, Fred" <fred.brandt@cz.nl>]

Thanx for the replies. 
The problem seemed to be in the On-Break itself, but the real problem was
the data in the array.
After adjusting the procedure that loads the array, the on-break works just
fine: when a higher level breaks (even if
the lower level doesn´t break) the on-break-procedures start up.
My mistake was to assume that the data in the array was correct without
checking what was really inside.

Fred Brandt


-----Oorspronkelijk bericht-----
Van: White, Denise [mailto:DEWhite@vicr.com] 
Verzonden: 26 January 2004 14:55
Aan: SQR Users Group (E-mail)
Onderwerp: [sqr-users] RE: On-break (lowest level identical while level
above breaks)


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



================================================================== 
De informatie verzonden met dit e-mail bericht is vertrouwelijk en
uitsluitend bestemd voor de geadresseerde. Indien bovenstaand e-mailbericht
niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het
e-mailbericht te retourneren aan de verzender en het origineel en eventuele
kopieën te verwijderen en te vernietigen. Gebruik van deze informatie door
anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging,
verspreiding en/of verstrekking van deze informatie aan derden is niet
toegestaan. CZ staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden e-mail, noch voor tijdige ontvangst daarvan. 

================================================================== 
The information contained in this communication is confidential and may be
legally privileged. If you are not the intended recipient of this
communication please return the communication to the sender and delete and
destroy all copies. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. CZ health
insurance is neither liable for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt. 

=================================================================== 


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