Select Ne Problem

[Deskin, Bob]

Are the datatypes different? Or are they both float? Floating point numbers
are not always exact. Depends how the value was derived.

Bob Deskin              
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: O'Sullivan, Kevin (K.M.) [mailto:kosulli3@cosworth-racing.com]
Sent: Monday, March 18, 2002 4: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.

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.