AnsweredAssumed Answered

Forming a field of type geometry in Geodatabase

Question asked by aviabunin on Dec 6, 2013
Latest reply on Dec 9, 2013 by aviabunin
Dear Gurus !
There is a table events with fields X, Y - containing the coordinates of points, which must be registered in the geodatabase. Created geodatabase cuks_gdb with standard tools of arcgis desktop 10.1. Table events copied in geodatabase :

select * into cuks_gdb.sde.events from cuks.dbo.events


3 . In the cloned table added field "shp" type geometry.

4 . Formed a field value by field values �??�??x, y:

update cuks_gdb.sde.events set Shp = geometry :: STGeomFromText ('Point (' + ltrim (STR (x, 99, 11 )) + '' + ltrim (STR (y, 99, 11) ) + ')' , 28406 );


All formed , error messages were not. But when I try to save changes in any field then I get an error message
The parameter type cuks_gdb.sys.geometry is invalid. Parameter name: value
How to fix ?

Attachments

Outcomes