I have a C# program set up to extract data froma VFP table via OLEDB.
I can seelct data fine, but if i try to use a data range in the select, I am getting errors when I run the select command.
I have tried a few options , inserting into the select string, using parameters, but none are sucessful.

Anybody know the correct syntax to e.g. Select from MyTable where Fld_date = ParamDate
Tia
Gerard