• Subject: RE: QMQRY editing question
  • From: Buck Calabro <mcalabro@xxxxxxxxxxxx>
  • Date: Wed, 7 Jul 1999 17:23:12 -0400

You are right - QMQRY will not let you use a "date" edit code with a
"numeric" column.  There is an alternative: retrieve the DDS source for the
file, modify it to put EDTWRD('    /  /  ') and use CHGPF to re-create it.
You won't get a level check, and your queries (QMQRY and QRY/400) will show
the proper formatting without any intervention.

Buck Calabro
Billing Concepts Albany, NY

> -----Original Message-----
> From: Dennis Munro 
> Sent: Wednesday, July 07, 1999 2:54 PM
> To:   'Midrange Users'
> Subject:      QMQRY editing question
> 
> In the Query/400 product, in the Report Column Formatting option you could
> do an F16 on the field whose edit code you wanted to change.  Change a
> field
> defined as numeric to a use the date edit code was a simple matter of
> changing the edit code to a "2".
> 
> In QMQRY, I am not finding a way to do the same thing.  I keep getting the
> error message QWM1515 " Edit code for column x not valid."  Under the Edit
> Column Formatting option I've changed the edit code to TDY/ (YYYY/MM/DD)
> and
> get the error when running the sample report.  Running with no edit code,
> the date is formatted with decimals and period just like a numerically
> defined field would be edited.
> 
> The field is defined as a packed 8,0 and the data displays like YYYYMMDD.
> 
> I'm guessing that QMQRY is not letting the date edit code be applied to a
> non date defined field while Query/400 didn't seem to care.
> 
+---
| 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-2019 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].