Re: Query problems

["Ken Sims at SWS Nevada" <ken.sws@xxxxxxxxx>]

Hi Jim -

>Date: Thu, 16 Sep 1999 08:11:13 -0700
>From: Jim Langston <jlangston@conexfreight.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.
...
>Which works, and gives me all the records.
>
>Is this a bug I'm looking at?  I'm on V3R7M0

In "Specify processing options" (the last option on the "Define
the Query" screen) you must set "Use rounding" to N.  Otherwise
your division statements will round instead of truncating.

Ken
Southern Wine & Spirits of Nevada, Inc.

+---
| 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
+---