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