Jerry,

I could be wrong (and somebody *please* correct me if I am!), but I think I remember reading somwhere (here probably) that this is a bug in VFP's OLEDB provider and will be fixed in the next release.

~~Bonnie


>Looks like the oleDbDataAdapter cannot create parameterized queries with VFP table. However, looks like it does work with Access data, etc...
>
>The way I found to do this was:
>
>oleDbDataAdapter1.SelectCommand.CommandText = "Select * from employee " +
> "where employee.lastname = '" + lc_search + "' order by lastname";
>
>dsEmpLast1.Clear();
>oleDbDataAdapter1.Fill(dsEmpLast1);
>
>Thanks
>
>Jerry
>
>
>>I'm using C# to create a WinForm to display a VFP table. I want the user to enter in a employee's last name and have the form look up that employee record from employee.dbf.
>>
>>I create an oleDbDataAdapter on the form and connect to a free VFP table. I build a SQL command as follows:
>>
>> SELECT * FROM employee WHERE (lastname = ?)
>>
>>My problem is that when I attempt to generate a DataSet, I get the following error message:
>>
>> Retrieving the schema for oleDbDataAdpater1 failed. No value given for one or more required parameters.
>>
>>How can I create a parameterized query in C#? Or what am I doing wrong?
>>
>>Thanks,
>>
>>Jerryt