David,

Sorry, I wasn't paying enough attention. It lookis like you're doing it right. One thing that can be helpful is creating a view in the view designer then using GENDBC.PRG to create the code needed to make the view. That will give you an idea of the settings you'll need.

>Master is the name of the cursor. Do I need to list every index field name?
>The error I am getting is "No key columns are specified for the update table 'master'. Use the KeyFieldList property of the cursor." I AM!
>
>DLC
>
>
>>>I am trying to change a cursor from SQL Server to be act like a remote view and I am getting an error on the keylist command.
>>>
>>>lnR = SQLEXEC(g_sql_h1,"select * from master order by mas_sqlkey", 'master')
>>>
>>>=CursorSetProp("Tables", "master", "master")
>>>=CursorSetProp("KeyFieldList", "mas_sqlkey", "master")
>>>=CursorSetProp("UpdateNameList", "mas_delet master.mas_delet")
>>>=CursorSetProp("UpdatableFieldList", "mas_delet")
>>>=CursorSetProp("SendUpdates", .T.)
>>>
>>>Any ideas?