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@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.

<<winmail.dat>>

_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Reply via email to