Sunday, April 22, 2012

Using Oracle Views with Mapguide / FDO

Using views in Oracle is a good way to access data via Mapguide/FDO,
but in order to be able to select a feature, it must have a primary key,
otherwise, selection will fail.

This is the SQL syntax to add a primary key on an Oracle View
alter view add constraint primary key () disable novalidate;

Once the view has a primary key, selection becomes available.


From the Mapguide Users Mailing list

No comments: