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.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould