AnsweredAssumed Answered

Obtain the identitity value from an insert

Question asked by fabianoferrazza on Nov 30, 2015

Hi all,

i need insert a row in a not SDE table and retrieve the identity id.

In sql is quite simple:

INSERT INTO TAB1 (val1,val2,val3) OUTPUT INSERTED.IDVALUES (0,1,2).

 

I can't use a direct SQL connection, i must use arcobjects.

 

The ISqlWorkspace.ExecuteSQL is ususable, because is void.

 

The dbms is SQLServer 2008 R2

 

Could you help me?

 

Thanks

 

Fabiano

Outcomes