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

[Orest Halustchak]

SQL Server has a number of requirements for setting up this view, it has to be a deterministic view and there are a number of settings that have to be defined such as SET ANSI_NULLS ON. Also you have to use SCHEMABINDING. I was able to set up a view this way and use Map to view the data and create new features. In MG, I was able to draw the layer and select the feature. My view was a simple view, though.

Could you post your view definition?

Thanks,
Orest.

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of miansi
Sent: Monday, February 16, 2009 4:07 PM
To: fdo-users at lists.osgeo.org
Subject: RE: [fdo-users] FDO 3.4.0 Beta 1 - SQL 2008 - empty schema


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.

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users