Select Ne Problem

O'Sullivan, Kevin (K.M.) kosulli3@cosworth-racing.com
Mon, 18 Mar 2002 04:53:28 -0500


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