I tried:

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

gives me

Command contains unrecognized phrase/keyword.

and

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

gives me

Missing operand.

>I think you are missing "@" in your syntax. I think it should be
>
>

>objCmd.Parameters.Add("@CustomerID", "ALFKI");
>

>
>HTH.
>
>>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?