Once you get passed the hump, it all gets pretty easy in VFP to access SQL*Server Data. Here is a quick example In its simplest form using a connectionstring (not the cursor adapter thing): (Note: I didn't test it, so there are probably errors in the text below!)
******************************************************************
strConnectionString = [Driver={SQL Server};Server=ServerNameHere;Database=YourDatabase;Uid=user_id;pwd=password]
strSQL = "select * from Names where intPK = '1' " && or what ever sql statement you are passing.
csrCursorToBeReturned ="csrNames"
intHandle = SQLSTRINGCONNECT(strConnectionString)
intResults = SQLEXEC(intHandle, strSQL, csrCursorToBeReturned)
***************************************************************************************************
You now have vfp cursor (csrNames) do play around with in pure VFP. ... and you can do updates and inserts and deletes the same basic way.
Kevin