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 <[EMAIL PROTECTED]> 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/
