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?