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?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.