Ole db Command

29 Aug 2006 6:35 AM

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

29 Aug 2006 7:14 AM

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

Show quoteHide quote

"Agnes" <ag***@dynamictech.com.hk> schreef in bericht
news:ubSvFVzyGHA.2640@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
>
>
>
>
>
>

29 Aug 2006 2:52 PM

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

Show quoteHide quote

"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:ubSvFVzyGHA.2640@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