The information in this article applies to:
SYMPTOMSYou 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:
CAUSEVisual FoxPro attempts to use the same temporary file name twice. STATUSMicrosoft has confirmed this to be a bug in the Microsoft products listed
at the beginning of this article. Q194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why MORE INFORMATIONAlthough 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
After approximately 839805 iterations, the error described in the SYMPTOMS section above occurs. Additional query words:
Keywords : kbDatabase kbSQL kbVFp600 kbVFp600bug kbVS600sp3fix kbGrpFox kbDSupport kbCodeSnippet |
Last Reviewed: August 31, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |