Hi BIll.
Got this working, finally

What did NOT work:
oCommX.Parameters.Add(new OleDbParameter("@MyDate", dtX));

What did work:
oDaX.SelectCommand.Parameters.Add("@MyDate", OleDbType.Date).Value = dtX;

I was just adding the Parameter to the Command , whereas your sample adds the Parameter to the SelectCommand Property of the DataAdapter..... I would never have figured that out in a month of Sundays , particulalrly as adding the Parameter to the Command object was not giving an error.


Many thabks again and I really appreciate your persistence.

Regards,
Gerard




>Gerard
>
>This works here:
>
>

>
> OleDbCommand oCommX = new OleDbCommand();
>      //string oConnX = @"Provider=VFPOLEDB.1; Data Source=" + @"C:\DISA\DIS2012";
>      string oConnX = @"Provider=VFPOLEDB.1; Data Source=" + @"C:\apps\safesoun\pro6\acdata";
>      string oSelX = "Select * from stores01 WHERE adddate <= ? ";
>      DateTime dtX = DateTime.Now;
>      OleDbDataAdapter oDaX = new OleDbDataAdapter(oSelX, oConnX);
>      oDaX.SelectCommand.Parameters.Add("@MyDate", OleDbType.Date).Value = dtX;
>      DataSet oDsX = new DataSet();
>      oDaX.Fill(oDsX);
></pre?
>
>
>
>>Hi BIll
>>Tried that 
>>
>>oCommX.Parameters.Add(new OleDbParameter("@MyDate", dtX));
>>
>>Same result I'm afraid (no value given for one or more required parameters)
>>regards,
>>Gerard
>>
>>
>>
>>>Gerard
>>>Try changing this:
>>>oCommX.Parameters.Add(new OleDbParameter("?MyDate ", dtX));
>>>
>>>to 
>>>
>>>this:
>>>oCommX.Parameters.Add(new OleDbParameter("@MyDate ", dtX));
>>>
>>>Confusing, but when you add it you use "@" and when you use it, you use "?"
>>>
>>>
>>>
>>>><pre>
>>>>Hi Bill. My code is below:
>>>>
>>>> OleDbCommand oCommX = new OleDbCommand();
>>>> string oConnX = @"Provider=VFPOLEDB.1; Data Source=" + @"C:\DISA\DIS2012";
>>>> string oSelX = "Select AAP_TITLE from DFAAP WHERE AAP_DATEBR >= ? ";
>>>> DateTime dtX = DateTime.Now;
>>>> oCommX.Parameters.Add(new OleDbParameter("?MyDate ", dtX));
>>>>OleDbDataAdapter oDaX = new OleDbDataAdapter(oSelX, oConnX);
>>>>DataSet oDsX = new DataSet();
>>>>oDaX.Fill(oDsX);
>>>>
>>>>If I Change the where clause to 1=1, rows are selected fine
>>>>The AAP_DATEBR is a Date Field in a DBF thats part of a .DBC
>>>>

>>>>
>>>>
>>>>
>>>>
>>>>>>

>>>>>>Hi Borislav
>>>>>>=======================================================
>>>>>>string oSel = "Select Myfield1,MyDate from MYTable WHERE MyDate <= ? ";
>>>>>>DateTime dt = DateTime.Now;
>>>>>>oComm.Parameters.Add(new OleDbParameter("?MyDate ", dt));
>>>>>>=======================================================
>>>>>>
>>>>>>Still get a message: No value given for one or more required parameters
>>>>>>Beginnig to think that maybe you cannot use parameters with OleDb and Foxpro and a Date Field and maybe I have to change 
>>>>>> to stringing in everything (and I know..leave it open to Sql Injection etc )
>>>>>>What do you think ?
>>>>>>Have you yourself ever got OLEDB with a Date Parameter to work ?
>>>>>>
>>>>>>Regards,
>>>>>>Gerard
>>>>>>

>>>>>>
>>>>>>
>>>>>>
>>>>>>>>Hi Borislav.
>>>>>>>>Yes I have seen Ricks link but nowhere do I see an example with a DATE in the parameter
>>>>>>>>Regards,
>>>>>>>>Gerard
>>>>>>>
>>>>>>>

>>>>>>>string oSel = "Select Myfield1,MyDate from MYTable WHERE MyDate <= ? ";
>>>>>>>DateTime dt = DateTime.Now;
>>>>>>>oComm.Parameters.Add(new OleDbParameter("?MyDate ", dt));
>>>>>>>

>>>>>>>
>>>>>>>?
>>>>>
>>>>>Gerard
>>>>>
>>>>>It might help to show all your code, including the code executing the command