[mapguide-users] FDO 3.4.0 Beta 1 - SQL 2008 - empty schema
Jason.Birch at nanaimo.ca
Mon Feb 16 15:47:48 EST 2009
MapGuide does not allow selection from tables/views without primary keys. Basically, without a primary key there is no way to ensure that you're selecting the correct object.
Have you tried setting up an indexed view? I don't have any experience with this, but...
I wonder if there is a way to create a configuratin file for your data source that specifies its schema (including a manual override of the primary key column). The FDO mailing list may be able to help...
Sent: Mon 2009-02-16 10:23 AM
To: mapguide-users at lists.osgeo.org
Subject: RE: [mapguide-users] FDO 3.4.0 Beta 1 - SQL 2008 - empty schema
On the map and inside my application I need to present information joined
from both tables. For that I created SQL view and used it.
Everything is OK, but I cannot select anything on this layer. I see features
on the map, I see mouse pointer changing its shape from ][ to arrow, but
neither clicking on feature nor selecting area, which includes multiple
features do select features.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 4764 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapguide-users/attachments/20090216/f8939763/attachment.bin
More information about the mapguide-users