[mapguide-users] Create layer from oracle database without spatial data

[Zac Spitzer]

to create spatial points from existing x y columns you can create wkt ie:

update region
set	poly=SDO_GEOMETRY('POINT(' || region.x || ' ' || region.y || ')', srid);


On Wed, Aug 13, 2008 at 8:39 PM, Zac Spitzer <zac.spitzer at gmail.com> wrote:
> did your table have a pk and what was the pk column type?
>
> z
>
> On Wed, Aug 13, 2008 at 8:33 PM, 0uch <hwayuyu at yahoo.com.tw> wrote:
>>
>> I used mapguide studio and enterprise 2009 to create a landmark layer by
>> using oracle view data, it's work , but the landmark on map can not be
>> select.
>>
>> Then I tried mapguide O.S. 2.0.1 with king.Oracle , it can create layer too,
>> but layer still can not be select.
>>
>> The select properties was setting correctly.
>>
>> Beside, the setting "Filter applied to data" in layer didn't work too,
>> whatever i set was useless.
>>
>> Is there something wrong with my oracle data ? or some setting I missed?
>>
>>
>> Dragan Podvezanec wrote:
>>>
>>> If you use king.Oracle provider, you could use King.FDO.Class and then use
>>> table without spatial data: detailed procedure is described here:
>>>
>>> http://www.sl-king.com/fdooracle/KingFdoClass.htm
>>>
>>
>> --
>> View this message in context: http://www.nabble.com/Create-layer-from-oracle-database-without-spatial-data-tp18848865p18960563.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
>



-- 
Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168