>>>Hi,
>>>
>>>I am trying to determine if how I am building values for properties UpdateFieldList and UpdateNameList for a CursorAdapter has a downside.
>>>
>>>What I am doing is dynamically (when creating a CA for a table) build the values of these properties bases on the structure of the table and include all columns of the table. That is, I do not exclude the PK column or any other column. Is there a potential problem with this approach?
>>
>>Yes, you should EXCLUDE the PK field from the list. If PK is identity field you can not update it anyway.
>
>But UpdateNameList must have PK field, otherwise, updates won't work; isn't it correct?

Did you try using Mark McCasland CA builder? It automatically constructs the commands based on all columns in a table.

Try it as a sample.