Actually I needed both with a list of all (not just one field) of the fields. I received some help from Tom Demay who has a program that takes a view and creates the UpdateFieldList and UpdateNameList. He is going to have a 3 part series in FoxPro Advisor sometime next year on this subject.
>David,
>
>It looks like you're defining the table correctly. I think you need to use UpdateNameList instead of UpdateFieldList.
>
>>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.)
>>---------
>>