>>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.
Using SCOPE_IDENTITY() is not that simple :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.