I am able to create a query layer from our 2005 SQL server and link shape files to it with an identity field without any error in ArcGIS Pro 1.1. However, if I modify the definition query in ArcGIS or modify the view on the server side the data in my query layer does not refresh. It returns the number of records I'm expecting but the values in all the fields for all the records are blank. I have to delete and recreate the query layer and then recreate the joins to the shape and layer files. Should I not be bothering to do this on a 2005 SQL server or am I missing something?
... View more