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