Infrastructure Map Server Forum
Welcome to Autodesk’s Infrastructure Map Server Forums. Share your knowledge, ask questions, and explore popular Infrastructure Map Server topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Ms Sql server feature class from query

2 REPLIES 2
Reply
Message 1 of 3
kalman_albert
526 Views, 2 Replies

Ms Sql server feature class from query

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

 

--------------------------------------------
"Nothing will ever be as it was!"
2 REPLIES 2
Message 2 of 3
jackie.ng
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

Message 3 of 3
gluckett
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).

 

 

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report