Shouldn't really have a decimal point in it. You should always store data in internal rather than external format.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 19 November 2004 10:11 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with EVAL in SELECT statement Tom, Here is a CT of the item. The field we are interested in is 25. Press any key to continue... 0022 0023 0.000225 0024 0.000225 0025 0.000225 0026 0.000225 0027 0.000225 Tom Dodds <[EMAIL PROTECTED]> wrote: What does the real data look like. CT that item, 00000048108, and lets see how the data is really stored. Tom Dodds [EMAIL PROTECTED] 630-235-2975 Cell 708-482-4510 Office -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: Wednesday, November 17, 2004 12:57 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with EVAL in SELECT statement Thanks for the suggestion but I want to know is why this doesnt work. What looks broken? "Allen E. Elwood" wrote:Looks broken. Why not make a dict to round it up to MD2 and then just select everything with a balance not equal to zero? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marco Manyevere Sent: Wednesday, November 17, 2004 08:10 To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] Help with EVAL in SELECT statement Martin, Here again: SELECT F.ACCOUNT WITH EVAL "ABS(BALANCE)" GT 0.01 15480 record(s) selected to SELECT list #0. >>LIST F.ACCOUNT EVAL "ABS(BALANCE)" .... 00000955485 1972.55 00000971405 114629.25 00000987328 45803.12 00000048108 0.0002 00002006146 54125.35 .... SELECT F.ACCOUNT WITH EVAL "ABS(BALANCE)" GT 0.01 15480 record(s) selected to SELECT list #0. >>LIST F.ACCOUNT EVAL "QUOTE(BALANCE)" .... 00000955485 "1972.55" 00000971405 "114629.25" 00000987328 "45803.12" 00000048108 "0.000225" 00002006146 "54125.35" .... Here is the DICT record for BALANCE 0001: D 0002: 25 0003: 0004: BALANCE 0005: 19R 0006: S Bottom at line 6. Martin Phillips wrote: Hi Brian, I can see that this will run on a bit.... > I think Mats is correct. > > The 'field' in question is an EVAL expression, so doesn't have its own > conversion code unless you explicitly state it using the CONV keyword. Hence > the confusion over the result. EVAL takes on the properties of the first item in the expression, in this case BALANCE. Regardless of what it is doing, the output of displaying BALANCE should be equivalent to the value used in the comparison. It would be interesting to see the results of EVAL "QUOTE(BALANCE)" as I thing this is going to show that the field is faulty in some way. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --------------------------------- Moving house? Beach bar in Thailand? New Wardrobe? Win #10k with Yahoo! Mail to make your dream a reality. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --------------------------------- Moving house? Beach bar in Thailand? New Wardrobe? Win #10k with Yahoo! Mail to make your dream a reality. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --------------------------------- Moving house? Beach bar in Thailand? New Wardrobe? Win #10k with Yahoo! Mail to make your dream a reality. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/