Just thinking through my fingers, could it be the data is being compared
character by character, not value by value? Maybe if you did something
like:
SELECT F.ACCOUNT WITH EVAL "ABS(BALANCE+0)" GT 0.01
Adding the +0 should force the contents of BALANCE to be numeric, not
character.
Bob Woodward
Programmer/Analyst
Harbor Wholesale Grocery
[EMAIL PROTECTED]
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of Marco Manyevere
> Sent: Wednesday, November 17, 2004 10:57 AM
> 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" <[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/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
