That's one of the easiest things in the world to overlook. Be sure it's checked again if you ever need to modify the view.
>Thanks Fred. That loud, yet hollow, sound you hear is my forehead bashing against the monitor. :-)
>
>Nothing like missing the forest for the trees :-0
>
>>>Using VFP6 SP5 and SQL Server 2000.
>>>
>>>I have a SQL Server view of 2 tables. If I issue an UPDATE against the view using SPT, the base table data is updated as well.
>>>
>>>If I create a remote view of the SQL view and update some data, TABLEUPDATE(1) returns .T., however, neither the SQL view or table have actually been updated. I determined this by issuing a SELECT ... against the table and view using SPT.
>>>
>>>Does anyone know why the data is not updating and what I can do to accomplish this?
>>
>>Did you check "Send SQL updates" when you created the view?