Rtos in MAP 2007

[acouture]

Querying polylines In MAP 2006, with this expression (rtos (/ .AREA 1000000) 2 2) in the "Output Report Options", I used to obtain a list of values at 2 decimals (square meters). In MAP 2007, it returns this list where some of the values have more than 2 decimals.

9,0199999999999996
10,890000000000001
9,7400000000000002
13,58
12,369999999999999
12,5
32,689999999999998
9,1500000000000004
9,2899999999999991
8,0800000000000001
76,480000000000004
11,84
16,98

DIMZIN set on all values (0,4,8,12) don't fix the problem.

If it could be helpful, I give the list returned by the expression .AREA (square millimeters);

9018335,0607364904
10894048,185090374
9739031,2360088434
13580840,388551589
12371782,951614641
12495082,020235304
32692524,151095875
9150665,0038432628
9289029,4362762142
8082295,802448906
76480607,069035426
11838586,440282393
16979013,689347323

Thanks

Andre

[jared.osborn]

I know this is an old entry - but found a workaround.  We use all external queries and wanted to string (number) sqf with our space type code (text).  Here are the key entry points:

Change the setvar (luprec) precision setting to 0 (or whever decimal places you want) and then reset back when query is done.

(setvar "cmddia" 0)

(setvar "luprec" 0)

(ade_altpdefine "TextObject" '(("TextValue" . "(STRCAT (rtos (fix ( / .area 144))) \"-\" (STRCAT &yourfield@yourtable))")("Justify" . "CENTER")("InsPt" . ".LABELPT")("Style" . "yourstyle")("Height" . "10")("Rotation" . "0.0")("Layer" . "Text")("Color" . "7")))

(ade_qryexecute)
(ade_qrysettype "draw")
(ade_qrydefine '("" "" "" "Location" ("all" )""))
(ade_qrysetaltprop T)
(ade_altpclear)

(setvar "luprec" 4)

(setvar "cmddia" 1)