RE: Query/400 question

[Jim Suiter <jsuiter@xxxxxxxxxxxxxx>]

<previous stuff asking about how to create a particular query has been snipped>

>       [And Brad Said:]  That's too bad.  That was my suggestion.  You
>should be able to write an RPG program in less time that it would take to
>solve this connundrum.  You'll be fighting with this query forever.  I've
>seen in a hundred times.


In my opinion, query seems to be one of the most under-utilized tools of RPG
programmers.  Why spend hours hard-coding a program to create a report when
you can create the same report in 15 - 20 minutes using query?  And if the
user decides that this field needs to go here and could you add this field,
etc, etc. it's no problem.

If he will be "fighting with this query forever" it is only because he needs
a better understanding of relational databases, not because of any
deficiency on the part the Query application.

I'm not saying query can do everything, but I've seen lot's of code written
to do something I could have done with query in a fraction of the time.  All
it takes is a good understanding of relational databases.

Jim



+---
| 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
+---