[mapguide-users] Mgos rounding number type column in Oracle
problem
Marius_360
marius at openspatial.co.za
Mon Jun 9 04:10:00 EDT 2008
I will try that, but something to note is that mapguide 6.5 read this column
correctly.
zspitzer wrote:
>
> 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
> _______________________________________________
> 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-tp17727692p17728282.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
More information about the mapguide-users
mailing list