OK, Dmitry ... it was just a guess ... I saw some code posted here before that used the "?" for the VFPOLEDB provider, so I thought maybe that was the problem.

~~Bonnie


>Bonnie,

>
>I use OleDb too. And I have used the syntax .Add("@CustomerID","Value") many times.
>
>>Dan,
>>
>>I'm not 100% sure (since I'm not using the VFPOLEDB provider), but I think the "@" sign, as Dmitry suggested, is for SQL. I think you need to use the "?" for OleDB. Try this instead:
>>

>>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = ?");
>>objCmd.Parameters.Add("?CustomerID", "ALFKI");
>>

>>
>>~~Bonnie
>>
>>
>>>I'm using the VFPOLEDB provider and I am creating a command object like this:
>>>
>>>

>>>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = ?");
>>>objCmd.Parameters.Add("CustomerID", "ALFKI");
>>>

>>>
>>>When I execute this command I am getting an OleDbException that says:
>>>
>>>

>>>No value given for one or more required parameters.
>>>

>>>
>>>How do I use the parameter collection to pass parementers to commands?