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

[Franz1965]

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.