[mapguide-users] Mgos rounding number type column in Oracle problem

[Marius_360]

NUMBER datatype without a precision specified. I've thought about creating
the column as a number datatype with a precision, but that won't be
practical for now. 

How is the Float column different from a Number column? I have never used it
before so it is strange to me.


zspitzer wrote:
> 
> how is the column defined?
> 
> i think float and double would not be rounded
> 
> z
> 
> 
> On Mon, Jun 9, 2008 at 5:20 PM, Marius_360 <marius at openspatial.co.za>
> wrote:
>>
>> Hi all,
>>
>> I've got another problem with oracle columns being read incorrectly. I
>> create a point layer in MgOS 2.0 and then read the rotation for the
>> symbol
>> from a number type column, which contains values like 0.2568 and 3.58769,
>> which is the angle for that entity in radians. Now the problem is MgOS is
>> rounding the values to the nearest whole number, which is a major problem
>> when converting the angle to degrees, as the values are now 0 and 4 and
>> that
>> causes a major difference in the degree angle.
>>
>> I am using Studio 2008 to author, DB is Oracle 10R2, MgOS 2.0 with newest
>> SL
>> King provider.
>>
>> Has anyone seen this before? This is quite an urgent problem, would be
>> nice
>> if this could be fixed without a time consuming work-around!
>>
>> Thanks in advance
>>
>> Marius
>> --
>> View this message in context:
>> http://www.nabble.com/Mgos-rounding-number-type-column-in-Oracle-problem-tp17727692p17727692.html
>> Sent from the MapGuide Users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
> 
> 
> 
> -- 
> Zac Spitzer -
> http://zacster.blogspot.com (My Blog)
> +61 405 847 168
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Mgos-rounding-number-type-column-in-Oracle-problem-tp17727692p17728079.html
Sent from the MapGuide Users mailing list archive at Nabble.com.