It depnds on how and where you execute cSqlCmd. Your local variables may be out of scope at that point.

BTW, it's better to post unrelated question in separate threads.

>2.
>
>if i executing this satament its working fine
>
>Value2 = 'Abc'
>Value3 = 'Xyz'
>Value4 = 'X1y1z1'
>
>cCondition = '123'
>
>cSqlCmd = "Update MyTable Set Field2 = ?Value2, Field3 = ?Value3, Field4 = ?Value4 Where Field1 = ?cCondition "
>
>But, if declare the variables as a local like 'Local Value2,Value3,Value4',
>Value2 = 'Abc'
>Value3 = 'Xyz'
>Value4 = 'X1y1z1'
>
>then i try to execute it, but while on executing the system is asking for "Input Value for Parameters"
>for each Value2, Value3 and Value4.
>
>
>Local Value2,Value3,Value4
>cCondition = '123'
>
>cSqlCmd = "Update MyTable Set Field2 = ?Value2, Field3 = ?Value3, Field4 = ?Value4 Where Field1 = ?cCondition "
>