Check FAQ #8153 How to make SQL Pass-Through cursor updatable or you can just send UPDATE commands using SPT.

>I am new to using SQL Express and have been having difficulty updating a remote table. Here's the scenario:
>
>I am querying a remote table residing on an SQL Express server using multiple joins. (Using SQL PassThrough commands. I am creating the view in code and using a connection string and SQLEXEC().) I then take the data and transfer it to VFP local tables. No problem, I was able to do this. I have a field on the remote table called the TransQueue which I want to update with a logical to indicate it was processed. I want to scan through each row in the remote view, and then update the FMS_processed field on the SQL table so when I query it again for unprocessed data, those records transferred will not be included in the query. I tried CURSORSETPROP's with nothing but errors. This seems to be a simple process but I'm hitting a wall....any help and/or code samples for this scenario will appreciated.
>I am using Win XP and VFP6 .
>
>Thanks in advance,
>
>Bill Todoro