Infrastructure Map Server Developer

Infrastructure Map Server Developer

Reply
Member
benjamim.net
Posts: 4
Registered: ‎05-06-2011
Message 1 of 2 (312 Views)

if I use an Oracle view I do not have access to the properties of this view?

312 Views, 1 Replies
05-30-2011 10:55 AM

I'm using a view to return data from some tables of Oracle, but when I use this viw as datasource, I can not get the properties returned from the bank. Whenever I use I will not have access to view the properties, but only see the spot painted?

Valued Mentor
gluckett
Posts: 426
Registered: ‎10-10-2003
Message 2 of 2 (26 Views)

Re: if I use an Oracle view I do not have access to the properties of this view?

11-02-2014 03:02 PM in reply to: benjamim.net
Add a constraint to your Oracle view to trick mapguide (AIMS) into thinking it has a primary key. (Wishlist - be able to do this from Studio)

alter view <viewname> add constraint <constraintname> primary key (<columnlist>) disable novalidate;
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.