>Hi,
>
>When adding a new record/row to a table (using CursorAdapter with SQL Server) I have noticed that the cursor does not automatically get the value of the newly created PK. So the PK field value in the cursor is out-of-sync with the table. What is the common practice in this case? Reload the values from the table (that is, calling Fill method of the CA)? or is there a better or more accepted practice?
>
>TIA.
Check Message ID:
1046712 Try using scope_identity() instead of @@IDENTITY there.
If it's not broken, fix it until it is.
My Blog