oledbparameter

[Agnes]

..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

 

[Eliyahu Goldin]

OLE DB providers use question mark as a parameter placeholder as opposed to
named parameters used by SQL Server.