Decimal Rounding in ArcSDE Feature Class

[lawrencegalakong]

Hi,

I'm maintaining an ArcSDE feature class which stores polygons with areas (in hectares). the area is stored in a Double field with precision 10 and scale 2. To calculate the area, I just used the Calculate Geometry function.

I noticed an error when it comes to the rounding of decimal value. Eg. If the value calculated is 123.66975, the field will completely disregard the third decimal value and simply store 123.66. Did anybody else have this problem? I tried Double and Float, both produced the same result. But I didn't notice the problem when working with shapefiles. any help please?

Thanks.

[VinceAngelo]

Please do not double-post, even if the old thread has been quiet for months.  Even a
"bump" on a suspected software fault is inappropriate -- If you want Tech Support
assistance, you really need to contact Tech Support (where they have queues to
prevent questions from falling through the cracks).  If this is more than a slight precision
issue, and really a software defect, then the two month gap has probably prevented
the fix from being included in 10.2.0.

- V