|
An I is an option but some of these queries are building summary/work files for use later in the job stream. Actually I got through yesterday, when one of the queries ran, gave me the "level check" msg I went in to wrkqry did the 2 f3 thing then went back and replied to the message with an R. P.S. I got them all fixed by kludging a client access macro, didn't completely automate but cut the time SIGNIFICANTLY (BTW I ALMOST made the 7 pm deadline I had (7:15.....) Mark Allen IS Manager Kelly's Kids markallen@kellyskids.com -----Original Message----- From: owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]On Behalf Of JFinney@omnia.co.za Sent: Wednesday, February 02, 2000 4:33 AM To: MIDRANGE-L@midrange.com Subject: Re : ? regarding Queries -We recently added fields to one of our "Master" files. All is -well except -for queries that run against that file, they are erroring out (i.e. -equivalent to a level check). The only way I know of to fix is -to WRKQRY on -that query with revise and exit. that works fine except I have -500+ queries -that use the file (DON'T ASK!!!!). Does anyone know of a way -to do a batch -type update, or at least some automated way to correct????? Hi, I won't ask but please feel free to reply to Colin's question (I'm also intrigued). When the error message comes up on the screen, do you have an option to ignore ? If so, perhaps consider adding an entry to the system reply list to send the message in question an "I" Regards John. +--- | 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 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 +---
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.