oledbparameter

..Parameters.Add(New OleDbParameter("@dotnet.itags.org.cocode", OleDbType.VarChar, 10,
UserName))
(A).CommandText = "select 'loginid' from 'coinfo' where 'loginid' = ? "
(B).CommandText = "select loginid from coinfo where loginid = @dotnet.itags.org.cocode "

When statment(B) executed, "missing operand" occurs.
However, when I change into statmnet(A) , Everythings go fines, WHY ?
Please help . I am using vs.2005 & vfp databaseOLE DB providers use question mark as a parameter placeholder as opposed to
named parameters used by SQL Server.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"Agnes" <agnes@.dynamictech.com.hkwrote in message
news:OEnaMVzyGHA.1936@.TK2MSFTNGP06.phx.gbl...

Quote:

Originally Posted by

.Parameters.Add(New OleDbParameter("@.cocode", OleDbType.VarChar, 10,
UserName))
(A).CommandText = "select 'loginid' from 'coinfo' where 'loginid' = ? "
(B).CommandText = "select loginid from coinfo where loginid = @.cocode "
>
When statment(B) executed, "missing operand" occurs.
However, when I change into statmnet(A) , Everythings go fines, WHY ?
Please help . I am using vs.2005 & vfp database
>