[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Multi Level ON-BREAK
- Subject: Multi Level ON-BREAK
- From: MRS RALINE D SMITH-REID <LQCK59A@PRODIGY.COM>
- Date: Sun, 6 Oct 1996 11:40:52 -0500
I am a new SQR programmer using SQR3. Currently, I am creating a
program that produces a count of UNIQUE PRODUCTS for each ACCOUNT. A
product is identified by 3 fields on a table.
I have created a control-break process to accomplish this task. My
break is on the ACCOUNT and the CONCATENATED PRODUCT (the 3 product
fields).
Can someone tell me if the above can be done with the ON-BREAK
command and if so an example would be appreciated. Also, which would
be more efficient when the query has the potential of capture more
than 50,000 records. Creating a control-break process or using the ON-
BREAK command.
Thanks,
Raline Reid