Select Ne Problem

[Edis, Bob]

G'day Kevin

I agree with Bob; the problem is probably with comparing two floating point
values.  Try converting both values to integer first then comparing them.
Can an INT type go up to 12 positions?

DEFINE v1 INT*12 = mcst * 3
DEFINE v2 INT*12 = pouc * 3
SELECT IF v1 NE v2

You still may not get what you want until using some level of rounding but
at least you can see what you are really comparing.

Regards,
Blue

(available for short term gigs, anywhere)

-----Original Message-----
From: O'Sullivan, Kevin (K.M.) [mailto:kosulli3@cosworth-racing.com]
Sent: Monday, March 18, 2002 3:53 AM
To: Powerhouse List Group
Subject: Select Ne Problem


Hi All.

Please excuse the rather simple (I think) question. (not sure if the
original post made it)

Given two data items as follows :-

 Element MCST                             NUMERIC   Size 12
&
   Decimal 3
&
   Input Scale  3
&
   Output Scale 3
&
   Significance 4
&
   Leading Sign "-"
&
   Trailing Sign " "
&
   Fill " "
&
   Float " "
&
   Picture  "^^^^^^^^^.^^^"
&

 Element POUC                             NUMERIC   Size 16
&
   Decimal 3
&
   Input Scale  3
&
   Output Scale 3
&
   Significance 4
&
   Leading Sign "-"
&
   Trailing Sign " "
&
   Fill " "
&
   Float " "
&
   Picture  "^^^^^^^^^.^^^"
&



When I try to perform a select :-

---snip---

Acc IM link ITNO to PN of POFIL

Sel if MCST Ne POUC

Rep ITNO MCST POUC

Go

---snip---

I get records where the two compared fields seem to be the same on
screen/report.

I assume that the difference in the size of the items might have something
to do with the problem.

I can force a match by defining two character based items, asc'iing the
original fields and then comparing the two defined items, but would like to
know how to do it properly.

thanks for any and all help.

Kevin

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.