Ole db Command

[Agnes]

..Parameters.Ad d(New OleDbParameter( "@cocode", OleDbType.VarCh ar, 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]]

Re: Ole db Command

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" <agnes@dynamict ech.com.hkschre ef in bericht
news:ubSvFVzyGH A.2640@TK2MSFTN GP06.phx.gbl...

.Parameters.Add (New OleDbParameter( "@cocode", OleDbType.VarCh ar, 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]

Re: Ole db Command

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
cindy@cindywine garden.com


"Agnes" <agnes@dynamict ech.com.hkwrote in message
news:ubSvFVzyGH A.2640@TK2MSFTN GP06.phx.gbl...

.Parameters.Add (New OleDbParameter( "@cocode", OleDbType.VarCh ar, 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