Re: Call Query

[D.BALE@xxxxxxxxxxxxx]

>But the report does not use the formatting that was
>set up in Query/400.  Is it possible to use that
>formatting?

Unfortunately, AFAIK, no.

>If not, is there an easy way to make a
>QMFORM for the QMQRY?

Easy?!?!?  No!  QMQRY, IMNSHO, is a piece of cr*p as far as being able to make
decent-looking reports.  The only way I would not just do all this using
OPNQRYF / RPG would be if there was already a query out there, and the
user/boss wanted the absolute quickest & dirtiest way to get it done *AND*
understood that the report isn't gonna look all that great.

You gotta look at this from a maintenance perspective, too.  Even if you are
able to muddle your way through this, is somebody down the line going to have
to maintain it?  Are they going to look at the cryptic source and wonder what
the h*ll possessed you to do this?

If you want a quick way to do nice-looking reports quickly using RPG and hate
using IBM's RLU (Report Layout Utility), get a copy of RDA (Report Design Aid)
- it looks and feels just like SDA and it's a heckuva lot easier to use than
RLU.  You'll be cranking out good-looking reports in no time.

Dan Bale
IT - AS/400
Handleman Company
248-362-4400  Ext. 4952

-------------------------- Original Message --------------------------

> Click the link below
> http://as400service.rochester.ibm.com/s_dir/slkbase.NSF/$searchform?Open&vie
w=w
> all
> In the search field write :
>
> Passing Parameters to a Query/400 Query
>
> The basic idea of the solution is in the select statement to write in the
> Select part:
>
> DATE      GE   :FROMDAT
>
> // Yes the : has to be there
>
> Save the query as normal i.e. a QRYDFN object.
>
> Run the Query with STRQMQRY and ALWQRYDFN(*YES) and set the variables in
> SETVAR
>
> I.e. in the above case:
>
> StrQmQry QmQRy(yourlib/yourqry) AlwQryDfn(*YES)
>      QmForm(*QMQRY) SetVar((FROMDAT 19991122))

This is a great tip!  But the report does not use the formatting that was set
 up
in Query/400.  Is it possible to use that formatting?  If not, is there an
 easy
way to make a QMFORM for the QMQRY?

Or is the answer RTFM?  ;-)
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---