• Subject: Re: Query conversion
  • From: "Dan Bale" <dbale@xxxxxxxxxxx>
  • Date: Wed, 8 Sep 1999 15:06:20 -0400


>>You can use the RTVQMFRM command to retrieve the output format from the
>>query, CRTQMFRM to create a form that can be referenced by the STRQMQRY
>>command. I've used this a few times and it has reproduced the Query output.

My experience trying to reproduce Query's printed output using RTVQMQRY,
RTVQMFORM, CRTQMFORM, CRTQMQRY, and STRQMQRY has usually left me exasperated to
the point where I just finally throw up my hands and re-do the whole thing using
OPNQRYF to get the data, and feed it into an RPG report program to print the
dang thing.  Note that the only reason I'd ever do this is because a user
requires a front-end data selection prompt to select the data to print on the
report.  Otherwise, I'd just stick with using Query.


>>The documentation for QMFORMs is among the worst ever written.  If you need
>>to modify one, be prepared to set a spell.  You can do some things in the
>>header and footer that you can't do with Query400.  Also the default width
>>for the QMQRY print file is 80 columns.  If you need wider printed output,
>>you'll need to override the print file.

And, by the time you've done all that, wouldn't you have been ahead just doing
the OPNQRYF / RPG route?

Just my $.02

- Dan Bale

| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 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].