General information
Title:
Retrieving Duplicate Records from Sever
Environment versions
Network:
Windows 2000 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only