Re: Opnqryf with Many Selections

["Jim Franz" <franz400@xxxxxxxxxxxx>]

I like RPG SQL. I can do some fine logic with this kind of search, check
results, maybe alter sql & go again, before presenting back to user. Can
control getting too many records much easier. The clp would be a mile long &
much slower.
jim franz
----- Original Message -----
From: "Pete Hall" <pbhall@execpc.com>
To: <MIDRANGE-L@midrange.com>
Sent: Friday, July 21, 2000 8:15 PM
Subject: Re: Opnqryf with Many Selections


> At 09:17 07/21/2000 , Pat Barber wrote:
> >I need to prompt for 7 paramters in a selection screen.
> >
> >Any or all of the parms can be entered, with the end result
> >being a collection of "and" conditions.
> >
> >The parms look like somthing along these lines:
> >
> >Agent     xxxxx
> >coverage  xxx
> >state     xx
> >inforce   (y/n)
> >underwriter xxx
> >company     xxx
> >payee       xxx
>
> Pat,
>
> When presented with this situation, I've usually constructed the select in
> a CL variable and then just used the variable in the query. This has the
> advantage that you have no "or" conditions, and you can set a breakpoint
on
> the OPNQRYF command and examine the contents of the select to make sure
> you've got all your quotes and parens coded correctly. I've found it
> relatively straightforward, if such a thing is possible with OPNQRYF,
which
> I rarely use these days because of the availability of embedded SQL.
>
> Pete Hall
> pbhall@execpc.com
> http://www.execpc.com/~pbhall
> +---
> | 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
+---