>>>Do the variables cNewFld1Val and cNewFld2Val have to be Private? I have them Local and they are in scope with the above command. But I am not getting results I expect. So, I thought maybe this is the problem.
>>>Please let me know. Thanks.
>>
>>Yes, they need to be private.
>
>Even though the variable are declared and assigned right before the string cSqlUpdate is created?
>How come I don't get an error?

Undeclared variables are private by default.