Okay, I'm looking for some way in Pick's AQL to print the value of the new
break at the top of a section of details instead of at the bottom of the
details.

ie.

*** cars
cars mustang
cars accord

*** trucks
trucks dodge ram
trucks gmc
trucks F150

And not:

cars mustang
cars accord
*** cars

trucks dodge ram
trucks gmc
trucks F150
*** trucks

Is there such an animal? Roll-on and break-on print the break data at the
end of a section of data. I'm looking at printing the break data before the
corresponding section of data.

Also, does anyone know what the SECONDARY modifier does in AQL statements,
and how does one use it.

Regards,

Dale

1) I'm not sure you can. Wouldn't that require "think-ahead" to know
what the totals are before the lines are processed?

2) The only SECONDARY I could find in EPick was Secondary List, used to
copy or compare an active list against an other list of ids (compare to or
copy to).

Mark


"Dale Benedict" <dale_knowspam_benedict (AT) flightcraft (DOT) ca> wrote

(As long as you don't want totals...)
Build an A-correlative to the tune of:
IF ND = "1" then "*** ":<attribute> else ""

--
frosty

Dale Benedict wrote:

AFAIK it is only possible in headings on page breaks.
I have been waiting for this feature more or less since I started with
Pick 20 years ago, but I don't think we'll ever get it, since hardly
anybody uses AQL these days anymore.
Maybe it's a thing for Jim to implement in Cache?

Mecki



Dale Benedict wrote:

I wouldn't need think ahead.. It would know what the heading should be
before it printed the first detail line because it must have already known
to do the "break" and any totals etc. on the preceding line.

Having said that, I don't think any of the Multi-value versions allow
this... .

Regards
Simon
"Mark Brown" <mbrown (AT) drexelmgt (DOT) com> wrote

And then sort on the "real" field and you should end up with
information on first & total lines

But like Mecki said, if you want an alternative OUTSIDE of AQL then you
can do this - certainly we can with our Visage.Reporter

I'm sure there are probably some "nifty" SREFORMAT style commands that
would let you do it, but I like the drag & drop idea too much these das
to bother :-)

"Mark Brown" <mbrown (AT) drexelmgt (DOT) com> wrote

I found the secondary by looking for AQL 'verbs' by listing the MD with a1 =
"C^""C^^". "SECONDARY" shows up on my listing with a1 = "c*". Attempting
to use SECONDARY in a listing in a few ways gave these results

:list md a1 secondary
[18] the last word may not be a connective.

:list md a1 secondary a2 a2
Page 1 md 07:29:31 06 May 2005

md............... a1...........................
a2...........................

! vs 17
# cd
%qfile.search6 q flight
%qfile.search8 q Mds
& c1
(p) cp
*a0 a 00
*a1 a 01
*a10 a 10
*a11 a 11
*a12 a 12
*a13 a 13
*a2 a 02
*a3 a 03

Here the listing seems to be sorted.

I dunno if this gives any hints. I'm going to post this to RD's discussion
form and see if I get any results.

Dale

The only way I now of is to use the option to include the break value in the
page heading and to have it do a page break on each break. I don't have
time to look in the manual for the options right now, but I have found them
in the manual before.

Matt Harting
Progressive Software Solutions

Dale Benedict <dale_knowspam_benedict (AT) flightcraft (DOT) ca> wrote

I'm not looking at creating a form feed at each break.

I think Frosty has a good idea that I'm going to explore.

Thanks to all who replied so far, and all those who have scratched their
head thinking about this one.

Dale

"Matthew Harting" <hartingm (AT) hotmail (DOT) com> wrote

Okay,

I got the answer for the SECONDARY 'modifier' in Pick's AQL...

It is the long form of the '(S' option. And so will create a secondary
list if used with a select statement.

Regards,

Dale

"Mark Brown" <mbrown (AT) drexelmgt (DOT) com> wrote