This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C1CE63.3CC6A4E0 Content-Type: text/plain; charset="utf-8" Hi Kevin, try qualifing the item names as below, Sel if MCST of filea Ne POUC of fileb -----Original Message----- From: O'Sullivan, Kevin (K.M.) [mailto:kosulli3@cosworth-racing.com] Sent: 18 March 2002 09:53 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. ------_=_NextPart_001_01C1CE63.3CC6A4E0 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: Select Ne Problem Hi Kevin,
try qualifing the item names as below,
Sel if MCST of filea Ne POUC of fileb
-----Original Message-----
From: O'Sullivan, Kevin (K.M.) [mailto:kosulli3@cosworth-ra= cing.com]
Sent: 18 March 2002 09:53
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 &n= bsp; &n= bsp; NUMERIC Size = 12 &nbs= p; &
Decimal = 3 = ; = ; = ; = ; = ; &
Input Scale = 3 = ; = ; = ; = ; = ; &
Output Scale = 3 = ; = ; = ; = ; = ; &
Significance = 4 = ; = ; = ; = ; = ; &
Leading Sign = "-" = ; = ; = ; = ; = ; &
Trailing Sign " = " = = = = = &
Fill " = " = = = = = &
Float " = " = = = = = &
Picture = "^^^^^^^^^.^^^" = ; = ; = ; = ; &Element = POUC &n= bsp; &n= bsp; NUMERIC Size = 16 &nbs= p; &
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
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
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.
------_=_NextPart_001_01C1CE63.3CC6A4E0--