Get back a new added ID from MS_SQL

i use the pro version with NET-Connector, togther with MS-SQL Server.

After adding a new Entry per code (extra forumlar does that work)
it would be fine if i could scroll to the new row.

For that i need then new id (AutoInc) from SQL Server.
How to get that id , and must i always refreh the whole grid after adding a new row?

Also is the a option to refresh only the updated row if server has hone a few calulations for that entry?

With best regards,
Uwe Janke

try onAfterUpdate event of the dataprocessor … fterupdate