topic Can query layer update if the row in database is updated? in Geodatabase Questions

Can query layer update if the row in database is updated?

PramudyaSeptian — Thu, 27 Apr 2017 03:06:59 GMT

I have feature class of provinces in my country and i have non spatial table in my geodatabase which contains all the attribute that i need to develop into thematic map in my company GIS application. However, this non spatial table is expected to be able to update every month. My questions are :

1. Is it possible for the service to be updated if the database is altered ?

2. Is it possible to style the thematic map based on the external table (non spatial table) ?

Thank you very much

Re: Can query layer update if the row in database is updated?

JoshuaBixby — Thu, 27 Apr 2017 13:24:29 GMT

Regarding your first question, i.e, "is it possible for the service to be updated...," what service? In your description of the situation, there is no mention of a service, so I am unclear what you are referring to.

Overall, it would help if you could provide some more information, beyond clarifying the "service" aspect. How do the features in the feature class relate to the records in the non-spatial table? Will it be a one-to-one or one-to-many relationship? What attribute are you using to join the fields?