I tried that also and of course it uses dbsetprop which has a different style.
Now, with the following code I am getting an error that the Update Tables is not being defined. I thought that maybe FoxPro was confused with the cursor and the table being the same name.
HELP!!!!
--------
lnR = SQLEXEC(g_sql_h1,"select * from master", "c_master")
=CursorSetProp("Tables","master","c_master")
=CursorSetProp("KeyFieldList","mas_sqlkey","c_master")
=CursorSetProp("UpdatableFieldList","mas_delet","c_master")
=CursorSetProp("SendUpdates",.T.)
---------
>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?