-->
This article helps you resolve the problem that occurs when you run an ODBC query against Visual FoxPro tables by using the Visual FoxPro ODBC Driver.
Visual Foxpro 6 0 free download - Learn Visual Basic 6, Microsoft Visual FoxPro 9.0 Service Pack 2.0, Service Pack 6 for Visual Basic 6.0, Visual C 6.0 with Visual Source Safe 6.0d, and many. Microsoft Visual FoxPro 6.0 Professional provides the tools you need to create and manage high-performance, 32-bit database applications and components. Its robust tools and data-centric, object-oriented language make it ideal for building modern, scalable, multi-tier applications that integrate client/server computing and the Internet.
Microsoft Visual Foxpro 6.0
Original product version: Visual FoxPro
Original KB number: 229854
Symptoms
When executing an ODBC query against Visual FoxPro tables using the Visual FoxPro ODBC Driver, no records are returned when the WHERE clause includes a date that is not in AMERICAN date format.
Cause
The Visual FoxPro ODBC Driver only accepts dates in a strict AMERICAN date format.
Resolution
Convert any dates that are passed in WHERE clause of the SELECT-SQL statement to an AMERICAN date format.
Visual Foxpro 6 0 free download - Learn Visual Basic 6, Microsoft Visual FoxPro 9.0 Service Pack 2.0, Service Pack 6 for Visual Basic 6.0, Visual C 6.0 with Visual Source Safe 6.0d, and many. Microsoft Visual FoxPro 6.0 Professional provides the tools you need to create and manage high-performance, 32-bit database applications and components. Its robust tools and data-centric, object-oriented language make it ideal for building modern, scalable, multi-tier applications that integrate client/server computing and the Internet.
Microsoft Visual Foxpro 6.0
Original product version: Visual FoxPro
Original KB number: 229854
Symptoms
When executing an ODBC query against Visual FoxPro tables using the Visual FoxPro ODBC Driver, no records are returned when the WHERE clause includes a date that is not in AMERICAN date format.
Cause
The Visual FoxPro ODBC Driver only accepts dates in a strict AMERICAN date format.
Resolution
Convert any dates that are passed in WHERE clause of the SELECT-SQL statement to an AMERICAN date format.
Status
This behavior is by design.
More information
The default Visual FoxPro date setting is AMERICAN. Date formats, however, may be set to the following formats:
Date Setting | Date Format |
---|---|
AMERICAN | mm/dd/yy |
ANSI | yy.mm.dd |
BRITISH/FRENCH | dd/mm/yy |
GERMAN | dd.mm.yy |
ITALIAN | dd-mm-yy |
JAPAN | yy/mm/dd |
TAIWAN | yy/mm/dd |
USA | mm-dd-yy |
MDY | mm/dd/yy |
DMY | dd/mm/yy |
YMD | yy/mm/dd |
SHORT | Short date format determined by the Windows Control Panel short date setting. |
LONG | Long date format determined by the Windows Control Panel long date setting. |
Steps to Reproduce Behavior
Foxpro Download Windows 7
Create a program file named Odbctest.prg, using the following code:
Happy summer walkthroughjpfasr. Observe that no records are returned or displayed.
Comment the following line of code:
Uncomment the following line of code:
Rerun the program and observe that data are returned and displayed on the screen. Download neat video 3.5 download.