RE: Interactive SQL question

[Dennis Munro <DMunro@xxxxxxxxxxxxxxxxxxxx>]

Thanks Buck.

You are right about the search engine.  I have a tendency to enclose the
search in quotes & this time I had used "interactive SQL".  Just trying to
find anything realizing SQL alone would return a "large" number of hits.  I
also had entered interactive SQL without quotes & still got a large number
of hits.

About making the subject line more meaningful makes sense.  Can't say I even
considered what it was being used for, i.e. feeding the Search engine.  I
will be more explicit/informative next time.

Again, thanks.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

-----Original Message-----
From: Buck Calabro [mailto:buck.calabro@aptissoftware.com]
Sent: Friday, February 02, 2001 3:58 PM
To: MIDRANGE-L@midrange.com
Subject: RE: Interactive SQL question

Dennis Munro wrote:

>I am trying to find some information on how to "code" column totaling. I
>have a report that selects qty, price, (qty * price) from a file but I
would
>like to total the three columns.  Looked through the Midrange archieves but
>you get tired of looking through 278 entries after 25 & they don't pertain
>to my question.

I can sympathise with the search engine.  The best thing to do there is to
spend some time and play with the keywords.  I have found that two keywords
work the best.  I used SQL TOTAL and quickly found the answer: use UNION.
Here's the link: http://archive.midrange.com/midrange-l/199911/msg00123.html
I have also found that hits less than 4 stars are rarely of interest.  I
only look there when truly desperate.

One thing that definitely hampers the search is the lack of correlation
between the subject and the problem.  This very thread will suffer the same
problem.  A better subject line might be "How do I show detail and total in
a single SQL SELECT?"

Buck Calabro
Aptis; Albany, NY
"Nothing is so firmly believed as
 that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.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
+---
+---
| 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
+---