>Hi everyone,
>
>Our company is writing a new application in .NET 2003 with the Mere Mortals framework, and we have to include a componenet that queries against VFP tables via OLE DB 6.0.
>
>Basically, the .NET component will query against a free VFP table to get any records that have a nonzero value in the Status field (integer) and a blank datetime value in the DTRANSMIT field. For whatever reason, the query returns 69 records via OLE DB, but if I run it in VFP against the same table, I get 2428 records.
>
>Here's the SQL statement we're trying to run through the OLE DB connection:
>
>select * from hcfahold where (status <> 0) and Cast(dtransmit as d) < {^'1900-01-01'}
>
>If anyone has any insight to get OLE DB to return the same number of records as VFP, I would sincerely appreciate it.
>
>Thanks,
>
>Ben Holton

What is SET('DELETED') status and do you have deleted records? Are the older dates empty in your VFP table? What type is dTransmit field?