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.