[mapguide-users] FDO 3.4.0 Beta 1 - SQL 2008 - empty schema

[Jason Birch]

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...
http://msdn.microsoft.com/en-us/library/dd171921.aspx
 
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...
 
Jason

________________________________

From: miansi
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
Type: application/ms-tnef
Size: 4764 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapguide-users/attachments/20090216/f8939763/attachment.bin