Article ID: 240436
Article Last Modified on 7/17/2007
APPLIES TO
- Microsoft Visual FoxPro 6.0 Professional Edition
This article was previously published under Q240436
SYMPTOMS
You run a program, method, or procedure that repeatedly issues SQL SELECT statements in a loop. After a very high number of iterations, the following program error occurs on a SQL SELECT statement:
CAUSE
Visual FoxPro attempts to use the same temporary file name twice.
STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
This bug was corrected in Visual Studio 6.0 Service Pack 3.
For more information about Visual Studio service packs, please see the following articles in the Microsoft Knowledge Base:
MORE INFORMATION
Although the code below uses the SELECT statement to create a cursor, you may also see this error occur with SELECTs that create files or arrays, because intermediate temporary files might be created when joins or unions are used.
Steps to Reproduce Behavior
Run the following code from a program (.PRG) file:
LOCAL lni SET TALK OFF CLOSE ALL CREATE TABLE table1(field1 i) INDEX ON field1 TAG field1 INSERT INTO table1 (field1) VALUE (1) USE FOR lni = 1 TO 1000000 IF MOD(lni,100) = 0 @ 2,2 SAY ALLTR(STR(lni))+" Iterations" ENDIF SELECT field1 FROM table1 ; WHERE field1 = 1 INTO CURSOR sqlresult NOFILTER USE IN sqlresult ENDFOR CLOSE DATA ALL- The iteration count is echoed to the screen. Let the program run for 839800 iterations. This may take quite a while, especially on slower computers. After approximately 839805 iterations, the error described in the SYMPTOMS section above occurs.
(c) Microsoft Corporation 1999, All Rights Reserved. Contributions by Jim Saunders, Microsoft Corporation.
Keywords: kbbug kbcodesnippet kbdatabase kbfix kbsqlprog kbvs600sp3fix KB240436
