>Thanks Naomi for the quick reply. I was able to open the view with no problems. I tried using SQLExec() and REPLACE FMS_Processed WITH .T. It didn't seem to work. I didn't try UPDATE. Since I have have to get up early tomorrow, I closed up my computer. I'll try it then. From what I read, I must first set the remote table as updatable with CURSORSETPROP() commands. I guess I then could use VFP code or do I still have to use SQLExec()?
>
>Thanks,
>
>Bill Todoro
I believe you can use VFP code and TABLEUPDATE to write changes back to SQL Server. I don't have much experience with Remote Views, I prefer using Cursor Adapter.
If it's not broken, fix it until it is.
My Blog