>>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");
>>

>>
>>How do I use the parameter collection to pass parementers to commands?
>
>Hmm...I could be wrong on this, but I don't think the OLE-DB driver supports parameters (maybe in 9?). I know I messed with this stuff sometime last year and ended up switching over to building the string myself.

Wait a sec, that's for views...A better answer is that VFP doesn't support named parameters, but positional parameters should work.

Hmmm...I don't have time to try this out, but here's a link to some code I posted for the MM.NET framework for creating a custom data access class. I've got to believe some variation of the code in there would work...

Thread#847134