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