AnsweredAssumed Answered

What's the best way to get the objectid for a new feature created using SQL and ST_Geometry?

Question asked by tedrakel_power on Mar 13, 2017

I'm using arc gis 10.2.1.  I create a point feature using SQL and ST_Geometry as shown below.  I need to know the objectid for this new feature.  Is it best to find the max(objectid) on the view after the row is inserted?

 

-- create a new point feature

insert into test_pt_evw (name,shape) values ('one', sde.ST_PointFromText('point (0.0125662 0.0046711)', 2))

--get the objectid for the new feature

select max(objectid) from test_pt_evw  

Outcomes