Opening, Updating data using vfp, sql server

[mariabenita]

I'am using visual foxpro 6, and MS SQL 7.0 as my back end. I already established connection to SQL Server and created remote views. When I used to update data, only the remote views was updated but no changes made to the base table on SQL Server. How can I update the base table on SQL Server?

Listed is part of my codes:

SET MULTILOCKS ON
= CURSORSETPROP('Buffering', 5, 'custview' )
replace empname with 'juan'
= TABLEUPDATE(.T.)

 

[foxdev]

If this is a persistent remote view (stored in a DBC), open it and its properties and make sure that:
A) Send Updates is checked
B) the key fields are properly identified. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com