Michelle,

Take a look at the DBSETPROP() function. It will allow you to set all of the properties of the view. You'll need to tell it to send SQL updates and also tell it each field you want to update and the name of the sql server table to update. All of this can be done with DBSETPROP(). An easy way to see an example of this is to create a view in the view designer and then run GENDBC.PRG. This will create a .prg that will create your dbc in code including any views. GENDBC.PRG should be in one of the subdirectories of your VFP installation (I think it's VFP\TOOLS\GENDBC).

>I first create a remote view from a table that resides on SQL Server 7.0 using the command 'CREATE SQL VIEW', then replace some of the fields within the view. So far so good, the fields in the view appear to have changed. Then I issue a TABLEUPDATE() and this is where the problems start. Modifying the view displays the fields with write properties, however the option 'SEND SQL UPDATES' is not enabled by default. I can find no way of setting this option, except when modifying the view manually.
>
>Please can someone help me get around this problem?
>
>Michelle