[mapguide-users] mapguide 2.4 sql server spatial feature source - can't select the data store and can't use join extensions

[Jose M. C. Marques]

Hi Jackie,

I' ve created a new spatial table with the same columns and data, but only with a primary key column and no foreign keys and then I've extended it in maestro and join it to a data table (also tried with a view).
This time the layer shows the objects, but I can't select them.
Tried the same tables and joins in mapguide 2.2 and the layer is shown and the objects are selectable.

Thanks,
José Marques

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jackie Ng
Sent: terça-feira, 12 de Fevereiro de 2013 10:55
To: mapguide-users at lists.osgeo.org
Subject: Re: [mapguide-users] mapguide 2.4 sql server spatial feature source - can't select the data store and can't use join extensions

This is most likely a leaky abstraction. Foreign keys are usually modeled as association properties in FDO, but there is no such equivalent in MapGuide.
Try joining against a view that filters out such foreign key columns.

- Jackie



--
View this message in context: http://osgeo-org.1560.n6.nabble.com/mapguide-2-4-sql-server-spatial-feature-source-can-t-select-the-data-store-and-can-t-use-join-extenss-tp5033688p5033692.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