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

[Zac Spitzer]

try number with precision then

there's a good explanation here (below the table)
http://www.ss64.com/orasyntax/datatypes.html

On Mon, Jun 9, 2008 at 5:54 PM, Marius_360 <marius at openspatial.co.za> wrote:
>
> 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.
>
> _______________________________________________
> 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