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

[miansi]

I moved post to FDO forum.

And yes. I tried indexed views - no luck.

I was wondering too if it is possible to specify in the layer XML or Map XML
that particular column is primary key.

Does anyone aware of such method? Can it be done?


Thank you


Jason Birch wrote:
> 
> 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.
> 
> 
>  
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/FDO-3.4.0-Beta-1---SQL-2008---empty-schema-tp2322472p2337221.html
Sent from the FDO Users mailing list archive at Nabble.com.