[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mapguide-users
Subject:    RE: [mapguide-users] Oracle FDO and View
From:       GordonL <gordon.luckett () arrowgeomatics ! com>
Date:       2009-05-29 13:24:45
Message-ID: 1243603485839-2993846.post () n2 ! nabble ! com
[Download RAW message or body]


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.

_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
[prev in list] [next in list] [prev in thread] [next in thread]