Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
Contributor
kalman.albert
Posts: 13
Registered: ‎09-30-2008
Message 1 of 3 (282 Views)

Ms Sql server feature class from query

282 Views, 2 Replies
07-12-2013 07:57 AM

In AIMS is not possible to select feature in the map if this come from query or view of Ms Sql Server Spatial 2008.

I can't understand this because the "query is hear of the database" how can we do GIS without query ?

 

Albert

 

Valued Mentor
jackie.ng
Posts: 284
Registered: ‎10-06-2008
Message 2 of 3 (269 Views)

Re: Ms Sql server feature class from query

07-14-2013 06:58 PM in reply to: kalman.albert

The FDO provider isn't very smart at picking up PKs from a view, so you have to send a "hint" to the FDO provider through the schema overrides mechanism that your view contains a unique identity property, thus allowing layers built off of it to be selectable.

 

http://themapguyde.blogspot.com.au/2010/08/using-fdo-schema-overrides.html

 

http://themapguyde.blogspot.com.au/2010/09/using-fdo-schema-overrides-redux.html

 

- Jackie

Valued Mentor
gluckett
Posts: 414
Registered: ‎10-10-2003
Message 3 of 3 (263 Views)

Re: Ms Sql server feature class from query

07-16-2013 05:13 AM in reply to: kalman.albert

Jackie, since this issue occurs on a regular basis (your first post on Schema Overrides is 3 years old),

do you think that putting an "Schema Override" tool within Maestro and Studio would be good solution? 

 

Many people use VIEWs in their Oracle and SQL Server databases to pull out spatial data and it would be great if we could choose the KEY ourselves within the AIMS Studio product (and Maestro of course).

 

 

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!