[mapguide-users] Oracle layer based on a view: I can't select

[Zac Spitzer]

you just need to indicate in the view which column is to be treated as
the pk, I think the directive is primary_key(g.fid) but you will need
to google this

On Sat, Apr 21, 2012 at 12:03 PM, Franz1965 <fsozzi at intercad.ch> wrote:
> Hi all,
>
> I have a problem on a specific view. Generally my views works fine with MG,
> but this wiew is not selectable by user and I don't understand why. It is a
> problem related to only this specific view.
>
> The view:
>
> CREATE OR REPLACE FORCE VIEW "WW_V_DSP_SECTION2"
> AS
>  SELECT g.FID,
>              g.GEOM
>  FROM WW_LINE g,
>            WW_SECTION a
>  WHERE g.FID_ATTR = a.FID;
>
> It is very simpe.
> WW_LINE is a table and if I directly use this one in the layer, I can select
> features.
> WW_LINE and WW_V_DSP_SECTION2 have both a primary key on FID and are both
> registered on USER_SDO_GEOM_METADATA.
> If I use WW_V_DSP_SECTION2 features are not selectable.
>
> Are ther a preferred command to create a primary key on a View to be mor
> compatible with FDO King driver?
>
> What I can check more? Anybody has any idea?...
>
> --
> View this message in context: http://osgeo-org.1560.n6.nabble.com/Oracle-layer-based-on-a-view-I-can-t-select-tp4903887p4903887.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users



-- 
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168