You may have to refresh the recordset to get the ID from SQL Server. Beyond that, Thread #
1515107 may be helpful.
>Hello,
>I am connecting to a SQL sevrver 2008 using ADO.
>In my vfp program, I have problem getting the value of auto-increment field after I do an rs.addnew and rs.update.
>The record is added/updated on the server side with no problem.
>
>I used to be able to get the value of the auto-increment field when I run the same program to connect to an MS Access DB
>
>Here is my connectin string:
>adoDBC.Open ("Provider=SQLNCLI;Database=pcMPISQL1;Server=insvb01038adx05;Integrated Security=SSPI")
>
>Any suggestion ?
>
>Thanks,
>Kam Lee
>SUNY DMC