[GIS] SDE views not showing values in joined table

attribute-joinsenterprise-geodatabase

I created an SDE view between a point feature class and a table (stored in SDE) – the join is done on a text field called RFRNC. I changed the view so that it is now a LEFT OUTER JOIN in line with this doc:

http://www.jamesrichards.com/post/2009/07/16/How-To-Create-an-ArcSDE-Spatial-View-With-an-Outer-Join.aspx

Problem is – when create a row in my flat table in the RFRNC column with a value I know exists in the featureclass – it never shows up or updates in the view – what is going on here? Any ideas greatly appreciated.

Best Answer

Apparently you just need to work with unversioned featureclasses - then it you see the values - elementary mistake! You need to change the Editor toolbar to work with unversioned datasets too.

Related Question