Hi Jon
Try
SET DECIMALS TO 5
Bruce
>In a piece of method code, I am attempting to create a string which includes a numeric value that specifically needs 5 decimal places. I thought I could save time by doing something like this:
>
>
>TRANSFORM(nRate, "99.99999")
>
>
>However, in a test case where nRate is 0.5425, the above statement returns 0.54. Interestingly enough, when no format code is used, TRANSFORM() will return 0.5425. Obviously, I know I can change the code to use ALLTRIM(STR()), but I don't understand why the above statement does any rounding whatsoever on a numeric value that clearly does not exceed the size of the format.
>
>Any ideas??
>
>Laterness,
>Jon