Hi Steven, did you find an answer to this?, if not here it it:
the UpdateNameList is just a list of "PAIRS" like this:

field1 dbo.MyBackEndTable.field1, field2 dboMyBakendTable.Field2,...fieldn dbo.MyBackendTable.fieldn

The UpdatableFieldList is just a list of the fields you want to be updatables

There is an utility here "SQL Pass-Through cursor that sends updates" that can make this job easier, is download # 22850

>Can someone please explain to me the syntax of the SPT code?
>
>What is the difference in the UpdateNameList and the UpdateableFieldList?
>Do both of these have to have the same field names?
>I have noticed that I can list the UpdateNameList in several lines of code but I can not get the UpdateableField List to read more than the last code line.