Hi David,

Yeah I'm still having trouble with this.
I ran your code, and sure enough it works the way you said.
I added the primary keys and check marked c1 to update and c2 did not show up on CURSORGETPROP('UpdatableFieldList')

My problem: I've triple checked my view. I have 2 fields that keep showing up on CURSORGETPROP('UpdatableFieldList'), but they ARE NOT check marked in the view designer. After looking closer they are the only 2 fields in that table that show up, all the rest of the fields in that table don't show up. Always before, I saw those 2 fields, so assumed that it didn't work the way I thought and quit looking further. So now I guess there's something wrong with my view and the way VFP 7.0 is storing it in the DBC.



>Bill,
>
>Are you still having a problem with this?
>
>CURSORGETPROP('UpdatableFieldList') only returns fields that are checked for update.
>
>CURSORGETPROP('UpdateNameList') returns all fields of a view
>
>check this rudimentary code fragment
>
>

create database billtest1
>
>create table bill1 ( i1 i, c1 c(10) )
>
>create table bill2 ( i2 i, c2 c(10) )
>
>create sql view viewbill1and2 as ;
>   select c1, c2 ;
>      from bill1 ;
>      inner join bill2 ;
>         on bill1.i1 = bill2.i2
>
>select 0
>use viewbill1and2
>
>cursorsetprop( "UpdatableFieldList", "c1", "viewbill1and2" )
>
>? cursorgetprop("UpdatableFieldList")
>? cursorgetprop("UpdateNameList")

>
>>Can any one think of a way to get a list of the fields that have a check mark next to them in the "Update Criteria" tab of the view designer?
>>CURSORGETPROP('UpdatableFieldList') and ('UpdateNameList') provide lists of all the fields.