RE: ? regarding Queries

Mark,

A couple of suggestions (none great).

1.      Issue an OVRDBF command with LVLCHK(*NO) prior to executing a query
        OR
2.      Retrieve the equivalent QMQRY source and then create the QMQRY
object from that source.
*       RTVQMQRY  with ALWQRYDFN(*YES)
*       CRTQMQRY from the retrieved source to create the QMQRY
*       STRQMQRY to execute the QMQRY

William K. Reger
Senior Project Manager
Levitz Furniture Corporation
Phone:  (561) 994-5114
E-mail:  breger@levitz.com <mailto:breger@levitz.com> 

                -----Original Message-----
                From:   Mark Allen [mailto:markallen@kellyskids.com]
                Sent:   Tuesday, February 01, 2000 11:24 AM
                To:     'MIDRANGE-L
                Subject:        ? 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?????

                Mark Allen
                IS Manager
                Kelly's Kids
                markallen@kellyskids.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
                +---
+---
| 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
+---