Re: Query problems

[Jim Langston <jlangston@xxxxxxxxxxxxxxxx>]

Actually, I had thought of that, Scott, and defining them as 6   0  or 4  0 or
2   0
doesn't seem to make a difference.

And this wouldn't explain why January and February would be included and not
march, they would have values of 2.something and 1.something.

And, when I add them together, InvYY * 100 + InvMM (in two separate lines)
and do math on that, everything is fine.  I *think* there might be something
wrong
with V3R7M0's use of ANDs and ORs, I've had lots of problems with it, things
that should work, don't, and I have to totally figure out some other way to do 
it

to get it to take something it should of taken in the first place.

Regards,

Jim langston

Scott Mildenberger wrote:

> You might double-check that InvMonth is defined with zero decimal places.
> Otherwise, for March dates it would end up with a value of 3.something which
> would cause them to be excluded.  This could explain what you are seeing.
>
> Scott Mildenberger
>
> > -----Original Message-----
> > From: Jim Langston [SMTP:jlangston@conexfreight.com]
> > Sent: Thursday, September 16, 1999 9:11 AM
> > To:   'MIDRANGE-L@midrange.com'
> > Subject:      Query problems
> >
> > I am having a problem in a query, that I did a work around for, but
> > don't' know why it happens.
> >
> > We have some dates in MMDDYY format stored as numbers.
> >
> > In a query I define some result fields as:
> > Temp1      ARINDT / 100
> > Temp2      Temp1 * 100
> > InvYear     ARINDT - Temp2
> > InvMonth   ARINDT / 10000
> >
> > Then, in my select records I have
> >             InvYear      EQ     98
> > AND    InvMonth   GE     10
> > OR       InvYear      EQ     99
> > AND    InvMonth    LE     03
> >
> > The whole idea being to get the range of records from 10/01/98 to
> > 03/31/99
> >
> > Well, it works but... I do no have any data for 03/xx/99  I have January
> > and February but not March, and I don't know why.
> >
> > To resolve this I finally made yet some more result fields:
> >
> > Temp3         InvYear * 100
> > InvYYMM   Temp3 + InvMonth
> >
> > Then, I select for
> >            InvYYMM   GE    9810
> > AND  InvYYMM    LE    9903
> >
> > Which works, and gives me all the records.
> >
> > Is this a bug I'm looking at?  I'm on V3R7M0
> >
> > And do you know of an easier way to do this?
> >
> > Regards,
> >
> > Jim Langston
> >
> > +---
> > | 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
+---