Re: WRKQRY - getting the SELECT records date range to show in the title

The &FIELD works in a QMFORM - those give you much more power, since you have the full range of SQL available to you. You can convert QRYDFNs to QMQRYs and QMFORMs easily, then go from there. You can even have substitution variables. STRQMQRY replaces RUNQRY.

Having said that, there are many similarities between the 2 types of query and presentation - I'd think the same thing works in Query but don't know for sure.

HTH
Vern

On 7/21/2010 7:04 AM, Peter_Vidal@xxxxxxxx wrote:

"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)