The &FIELD method only works in QM queries, not WRKQRY.
AFIK, the original query product did not have this ability.
You can easily convert your old query to a QM query and then change the
headings.
Thanks,
Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical
Solutions Implementer V5R3
________________________________
From: "Peter_Vidal@xxxxxxxx" <Peter_Vidal@xxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Wed, July 21, 2010 8:04:56 AM
Subject: Re: WRKQRY - getting the SELECT records date range to show in the title
"You can use &FIELD, where FIELD is the field name from a file. I would
imagine that it would also work on a derived field. I think that it must
be specified in upper case, but it's been a while since I've used that
feature, so I'm not 100% sure.
-mark"
Hi Mark!
I tried both ways (a field from a file and a work field), always in
uppercase, and it does not work like that. Looks like this &FIELD is
simply treated as a constant value and is not interpreting it as a field
value. You will have the title "&FIELD" included in your page headings
and or footings, that is all .
Can you give us an example of how you do it?
PETER VIDAL
PALL CORPORATION
SR System Analyst | WH Application Development
10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111
727-815-3104 | Fax: 727-815-3120 | www.pall.com
"Imagination is more important than knowledge"
Albert Einstein (1879 - 1955)
midrange.com
