Dear all,

1.
i m using Sql Server with Vfp 8.0, i pass one sql satament to server like
cSQLcODE = "select code As Abc, name As Xyz from SqlServ.dbo.Mytable where flag=2 and stat='A' Order by name"
select mytable
brow

but this duplicating the recoreds(Each Records comes two times), how i will supress the duplicating
the records.

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 "

Any body have an idea?

Regards
Abduall