zspitzer wrote
>
> cool, hey can you post the syntax for other to see?
>
Yes, for sure.
I've used exactly this one:
ALTER VIEW ww_v_dsp_section ADD CONSTRAINT pk_ww_v_dsp_section PRIMARY KEY
(fid) RELY DISABLE NOVALIDATE;
In my case "fid" is candidate key for the view (it has unique values).
http://osgeo-org.1560.n6.nabble.com/Oracle-FDO-and-View-tt4191962.html#a4191973
--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/Oracle-layer-based-on-a-view-I-can-t-select-tp4903887p4905225.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
___
cool, hey can you post the syntax for other to see?
On Sat, Apr 21, 2012 at 5:18 PM, Franz1965 wrote:
>
> zspitzer wrote
>>
>> 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
>
> Hi Z
zspitzer wrote
>
> 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
Hi Zac,
Thanks for suggestion.
Yes I've manually rebuilt primary key (the view had one) and now it works
:-)
--
V