I have inherited a QRY that was created before 2020. It has been running
daily ever since until this weekend.
The QRY is a complex QRY with 18 files.
Does anyone know of a way to get a dump of the values in the fields of the
QRYDFN when it fails? DMPJOB does not work.
I tried converting to a QMQRY to get the SQL. The SQL produces no errors
but returns an empty list of records. I see some records when working in
WRKQRY and use F5 to display the report and it does give me records. The
column in error has ++++.
I need to see the contents of the fields at the time to locate the problem.
TIA, Darryl Freinkel.
This mailing list archive is Copyright 1997-2026 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.
midrange.com
