Microsoft KB Archive/191926

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

Article ID: 191926

Article Last Modified on 5/11/2007

-

APPLIES TO


 * Microsoft Open Database Connectivity Driver for Visual FoxPro 5.0

-



This article was previously published under Q191926



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://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx



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.



Steps to Reproduce Behavior

 * 1) Create a data source on the Tastrade database.
 * 2) 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.

Keywords: kbbug kbfix kbvfp600fix KB191926

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.