oledbparameter

  • Thread starter Thread starter Agnes
  • Start date Start date
A

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
 
OLE DB providers use question mark as a parameter placeholder as opposed to
named parameters used by SQL Server.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fail to use oledbparameter 3
Ole db Command 2
vfp oledbcommand [Fail] 4
Missing operand 10
oledbcommand 1
parameter query in MDB 1
Textbox and SQL query 5
recover .vb source code in ASP .NET 3

Back
Top