Ole db Command

[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

[Cor Ligthert [MVP]]

Agnes,

Are you throwing in questions about this problem everytime new in this
newsgroup before reading the ones you have stated some short time before
that?

At least I get the idea about that

Cor

"Agnes" <ag***@dynamictech.com.hkschreef in bericht
news:ub**************@TK2MSFTNGP06.phx.gbl...

.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

[Cindy Winegarden]

Please see my reply to your earlier thread. It's preferable to keep the
whole issue in one thread.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
ci***@cindywinegarden.com
"Agnes" <ag***@dynamictech.com.hkwrote in message
news:ub**************@TK2MSFTNGP06.phx.gbl...

.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