Microsoft KB Archive/221690

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

Article ID: 221690

Article Last Modified on 3/18/2005

-

APPLIES TO


 * Microsoft Visual FoxPro 6.0 Professional Edition

-



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



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.

Keywords: kbbug kbfix kbsqlprog kbxbase kbdatabase kbctrl kbvs600sp3fix KB221690

-

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

© Microsoft Corporation. All rights reserved.