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