We found a bug related to remote views in our work with SQL server 7. This bug exists in VFP 6 with SP3.

Problem:

VFP Remote view on a SQL Server table with a TEXT field. If the memo field is updated, the view sends updates to the backend server, but marks the record as deleted in the view.

You can repeat the problem with a simple remote view connected to the example PUBS database that comes with MS SQL Server. Add a view to the pub_info table that includes the TEXT field.


Bring up a browse window , and modify the memo field (add anything) in one of the records.

In the command window, type

tableupdate(.t.,.t., 'pub_info')

while keeping the browse window open. After the update has been sent, the record is marked deleted in the view. The record is (correctly) NOT deleted on the backend.