FIX: You receive a C0000005 error message after you repeatedly execute a SELECT-SQL statement that uses the BETWEEN() function in Visual FoxPro 6 (221690)

The information in this article applies to:

Microsoft Visual FoxPro for Windows 6.0

This article was previously published under Q221690

SYMPTOMS

Microsoft Visual FoxPro 6.0 crashes with a C0000005 error message after you run a SELECT-SQL statement that uses the BETWEEN() function. Repeatedly requerying a view that is defined by using the BETWEEN() function might also cause this problem.

This problem can be intermittent and may only occur on certain computers.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

This bug was corrected in Visual Studio 6.0 Service Pack 3.

For more information about Visual Studio service packs, click the following article numbers to view the articles in the Microsoft Knowledge Base:

194022 Visual Studio 6.0 service packs, what, where, why

194295 How to tell that a Visual Studio service pack is installed

MORE INFORMATION

Steps to reproduce the behavior

Copy the following code into a new program file in Visual FoxPro:

SET STRICTDATE TO 0
FOR q=1 TO 1000
   WAIT WINDOW TRANS(q) NOWAIT
   SELECT * FROM HOME(2)+"data\orders" ;
   WHERE order_date BETWEEN {07/03/19963} and DATE() ;
   INTO CURSOR junk
ENDFOR

Save and run the program.
If the computer is subject to the problem, Visual FoxPro should crash with a C0000005 error somewhere between 10 and 20 times through the loop.

Modification Type:	Major	Last Reviewed:	3/18/2005
Keywords:	kbBug kbCtrl kbDatabase kbfix kbSQLProg kbVS600sp3fix kbXBase KB221690