Re: Query problems

[Rob Berendt <rob@xxxxxxxxx>]

The usual suspects when trying to use numbers with Query are to check 
your processing options.  Could be a truncation situation.

However, use the DATE function in your result field and convert to a real date 
first.  Online help and manual are good.  And this is supported under V3R7.





jlangston@conexfreight.com on 09/16/99 11:36:27 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
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
+---