Select to view content in your preferred language

Obtain the identitity value from an insert

2739
0
11-30-2015 03:03 AM
FabianoFerrazza1
Occasional Contributor

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

Tags (1)
0 Kudos
0 Replies