Re: OPNQRYF questions...

[Boris Goldenberg <bpcsguru@xxxxxxxxx>]

Why would you want to use OPNQRYF, when SQL is so much better in terms of
readability and ease-of-maintenance?

I suppose you can use OPNQRYF's with work files but I recommend redesigning the
application to take advantage of SQL.

Regards,
Boris Goldenberg

--- Mary Koetting <Mary_Koetting@mail.mchcp.org> wrote:
> 1.  I want to use a series of OPNQRYFs where the results of the first is
> used in the second and those results used in a third, is this even possible?
> 
> 2.  If the OPNQRYF is joined with the record format specified, what file is
> the opened one?  Is it the first one specified in the join, or the one
> specified as the record format?
> 
> Examples would be helpful as the books aren't...  Thanks!
> +---
> | 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
> +---
> 
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.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
+---