|
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)
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.