Select to view content in your preferred language

Cannot Select or Identify an SDEVIEW in ArcMap

756
2
07-19-2011 12:28 PM
Faustina_FosuaAnkomah
Deactivated User
I created an SDEVIEW using sdetable -o create_view command. The source feature class has ST_Geometry as the config keyword and I able to identify and select the feature class in ArcMap. The sdeview displays, zoom in/out but I am not able to select or identify the sdeview in ArcMap. I did check the object grants and privileges for ST_Geometry and they are all in place.
0 Kudos
2 Replies
VinceAngelo
Esri Esteemed Contributor
The best way to create a view which includes an ST_GEOMETRY column is to use SQL to
define the view, making sure that it returns a NOT NULL integer (SE_INT32_TYPE) column,
then to use 'sdelayer -o register' on the view, with the INT32 as a USER-set registered rowid
column.

- V
0 Kudos
Faustina_FosuaAnkomah
Deactivated User
Vince,

I applied ArcSDE 9.3.1 SP2 and it did resolve the issue. I am able to create the view with sdetable -o create view, select and identify the spatial view feature created on the map.

Thank you.
0 Kudos