Re: sum in SQL?

Sounds like a nice product. But STRQMQRY gives you some of that
functionality and is included in OS/400 - and might be adequate for many
projects. E.g., if you have a replacement variable but do not specify its
SETVAR on STRQMQRY, you are prompted for the value. As someone mentioned,
you don't even have to get the SQL licensed product, unless you want to
customize reports more easily than fighting with query management tags.

Drill down is NOT a part of it, however.

All in all, IMO, an under-utilized, very flexible mechanism.

Cheers

Vern

At 06:31 AM 12/12/2002 -0600, you wrote:

Nah, too much effort, even if you're doing it for a report. What's even
cooler is the ability to prompt for the variable when the user clicks an
icon on their desktop, and launches the ViewPoint piece of the software.

I just did a project for a JDE client in Cleveland. The client was having
problems with highlighting its problem receivables. I created a view where
the collector is prompted for a collector code and the number of days old
for outstanding invoices. A few seconds after clicking OK, a display pops up
showing customer number/name, amount, invoice number, contact info and age
of the invoice. This is sorted in descending order by age, so the collector
can "go get 'em". Also, while the collector is talking to the customer, and
needs to see details about an invoice, they can then "drill down" to the
invoice line item level.

-snip-

Paul Nelson
630-327-8665 Cell
708-923-7354 Home
----- Original Message -----
From: "Don" <dr2@cssas400.com>
To: <midrange-l@midrange.com>
Sent: Wednesday, December 11, 2002 9:30 PM
Subject: Re: sum in SQL?