[mapguide-users] Oracle FDO and View

[GordonL]

Thanks Bruno!  I added that contraint to the VIEW and voila!

MVIEWS might be faster, but the VIEWS are "real-time".



Bruno Scott wrote:
> 
> This is the SQL syntax to add a primary key on an Oracle View
> 
> alter view <viewname> add constraint <constraintname> primary key
> (<columnlist>) disable novalidate;
> 
> Once the view has a primary key, selection becomes available.
> 
> Bruno
> 

-- 
View this message in context: http://n2.nabble.com/Oracle-FDO-and-View-tp1811392p2993846.html
Sent from the MapGuide Users mailing list archive at Nabble.com.