Hi David,
Misunderstanding here.
I have a view: (note no fields are selected from t3, just used for filtering)
Select t1.Field1, t2.Field2 ;
from t1, t2, t3 ;
where t1.Key1 = t2.Key1 ;
and t2.Key2 = t3.Key3 ;
and t3.Flag
CURSORGETPROP("UpdateNameList") returns 't1.Field1, t2.Field2' (just what I expected)
but:
CURSORGETPROP("Tables") returns 't1,t2' (I expected 't1,t2,t3')
Is this the way it's supposed to be?
IOW:
Can I COUNT ON CURSORGETPROP("Tables") only returning a list of tables that are included in CURSORGETPROP("UpdateNameList")?
>Bill,
>
>
>Is there any way to get a list of fields that may be updated from a view (IOW have a check mark next to them in the "update criteria" tab of the view designer)?
>>
>>CURSORGETPROP("UpdatableFieldList")and CURSORGETPROP("UpdateNameList") don't say whether the field is checked.>
>UpdatableFieldList is a list of the updateable fields, the ones checked as update.
>
>UpdateNameList is the full list of fields in the view.
>
>
>
>CURSORGETPROP("Tables") doesn't always return a complete list of Tables.
>>I think I've determined that it only lists those tables that are included in CURSORGETPROP("UpdateNameList").
>>Is that right?>
>Yes, it only gives you the tables involved in the view.
>
>If you want all of the tables of a DBC look at DBGetProp()
Bill Morris