FIX: VFP ODBC Driver Problem w/ {d 'yyyymmdd'} and Year > 1999

ID: Q191926

The information in this article applies to:

Microsoft ODBC Driver for Visual FoxPro, version 5.0

SYMPTOMS

No records will be returned to a calling application if it passes date criteria using the following syntax:

{d '2000-01-01'}

RESOLUTION

Download the current Visual FoxPro ODBC driver from the Microsoft Data Access Components available from the following URL: http://www.microsoft.com/data/

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This bug has been corrected in Microsoft Visual FoxPro ODBC Driver, version 6.00.8167. The ODBC driver ships with the Microsoft Data Access Components version 2.0, Microsoft Visual Studio 6.0, and Microsoft Visual FoxPro 6.0.

MORE INFORMATION

Steps to Reproduce Behavior

Create a data source on the Tastrade database.

In a product, like MSQuery, create and run the following query:


Select * from Orders
         where Order_Date between {d '1997-01-01'} and {d '2000-01-01'}

This query fails to return records that match the criteria.

Depending on the version of TasTrade being used, the OrderDate field name could differ. Please check this and change the name in the SQL statement as necessary.

For more information about how Microsoft products are affected by year 2000 (Y2K) issues, please see the following Microsoft World Wide Web site:

http://www.microsoft.com/y2k/

Additional query words:

Keywords : kb2000 kbODBC kbVFp500abug kbVFp600fix
Version : WINDOWS:5.0
Platform : WINDOWS
Issue type : kbbug