Re: Running a QRYDFN using STRQMQRY to pass the parameters

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

All the responses are good, and I've done them.
However a totally different method might be to put your parameters into a
file and then join to that in your query.  So, you would have an initial
prompt screen (or some other method) to populate your parameter file.  Then
that parameter file would just be another file in your query to join to.
This way the users can modify the query to their hearts content (as long as
they don't blow the join) and you're good.

On Mon, Jan 30, 2023 at 4:41 PM a4g atl <a4ginatl2@xxxxxxxxx> wrote:

> I've read a few places that this can be done, saving one having to convert
> a QRYDFN to a QMQRY.
> I have tried to find examples on how to do this, but have not had success.
> The examples I find show the QRYDFN being run but there are steps missing,
> it appears. I need to keep the QRYDFN's as the users create the reports. I
> am trying to schedule the queries in the scheduler passing from and to
> dates.
>
> Does anyone know how to do this?
>
> TIA, Darryl Freinkel
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.