>>>
>>>cSqlUpdate = "update mytable set field1 = ?cNewFld1Val , field2 = ?cNewFld2Val where pk = 10"
>>>lnResult = SQLEXEC( nSqlHandle, cSqlUpdate)
>>
>>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, this is the only case I know of where you need to declare the variables as private.
Dim echoes of something view-related also ***needing*** private vars... But that is SQL by another name ;-)