RE: Query question

[Jim Cannon <JimC@xxxxxxxxxxxxxxxxxxx>]

AMEN BROTHER!!! PREACH IT!

> -----Original Message-----
> From: Dean Booth [SMTP:dbooth@injectronics.com]
> Sent: Friday, August 18, 2000 7:25 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: Query question
> 
> I don't know about backwards, but the fact that we need these clever
> workarounds
> in order to do conditional defines is absurd.  My vote for the most clever
> goes
> to the person using data as a parameter in the substr command.
> 
> I was going to submit my "zipneg" logic, where I create a field that is
> equal to
> zero if another numeric value is negative.  Turn off rounding, add a big
> constant
> to your value and divide by the same big constant.  You'll get 1 if the
> number is
> positive, 0 if negative ("zip" if "neg"-ative) provided your big constant
> is
> bigger than any value of the data.  Then multiply your data by zipneg to
> eliminate negative values.
> 
> After coming up with this trick I was briefly proud of myself, then I
> shuddered
> in horror as I realized where my career path had taken me.  Does "stone
> knives
> and bearskins" ring any bells?  Don't get me wrong:  I deeply appreciate
> how much
> effort the developers of Query put into functions that process time to the
> microsecond, and also DBCS processing.  One of these days I'm going to
> find out
> what DBCS is.
> 
> What do you all use to quickly pump data out of the system?  What products
> out
> there are *lots* better that Query?
> 
> thanks, Dean
> 
> "Draper, Dale" wrote:
> 
> > Uh, aren't we going backwards here? This whole thing started when
> someone
> > decided that On/Off could be replace with 1's and 0's. :)
> >
> > +---
> > | 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
> +---
+---
| 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
+---