Hi Mark.
Thanks for replying.
I eventually got it to work... I had been coding in named paramneters .OLEDB does not allow named parameters and this was most of my problem, so I had to use ? as positional parameters
Regards,
gerard



>>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
>
>This works for me in Excel VBA. As far as the date format is concerned, it should be the same in .net.
>
>{^yyyy-MM-dd}, ie {^2011-08-06} for today.
>
>

>Sub connectRough()
>Dim cDBC As String: cDBC = "C:\data\plucz\plucz.dbc"
>Dim pADOConn As New ADODB.Connection
>pADOConn.Open "Provider=VFPOLEDB; Data Source= " & cDBC & ";Password='';Collating Sequence=MACHINE"
>Dim mrs As New ADODB.Recordset
>Dim d As Date: d = DateSerial(2008, 12, 8)
>Dim cSQL As String: cSQL = "select * from badge where bdg_creationdate = {^" & Format(d, "yyyy-MM-dd") & "}"
>mrs.Open cSQL, pADOConn
>Debug.Print mrs("bdg_name")
>End Sub
>