Hi, Aleksey.
>CursorAdapter.AfterInsert event is the place to refresh AUTOINC values during TABLEUPDATE.
>
>For ODBC or ADODB.Command based Insert, execute SELECT @@IDENTITY using the same connection and simply replace value for the local field. This method might not work as expected if Insert command inserts into more than one IDENTITY field.
>
>For ADODB.Recordset based Insert, move to the last record in the Recordset, get value from its field and replace the local field. This method (moving to the last record) works for adOpenStatic recordset, I am not sure how it'll work for different recordset type.
This is exactly what I wanted. It's great to have you around.
Best regards,