Thanks for the suggestion but I want to know is why this doesnt work. What looks broken?
"Allen E. Elwood" <[EMAIL PROTECTED]> 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/
