The information in this article applies to:
SYMPTOMSWhen you execute a SELECT-SQL statement, which uses a subquery, when the SELECT executes, Visual FoxPro exits with an Access Violation (under Windows NT) or an Invalid Page Fault (Windows 95). STATUSMicrosoft has confirmed this to be a bug in the Microsoft products listed
at the beginning of this article. MORE INFORMATIONSteps to Reproduce BehaviorNOTE: The following causes Visual FoxPro to exit, and you could lose unsaved data.Run the following code from a program (.prg) file:
Under Windows NT 4.0, Visual FoxPro terminates on the SELECT statement with an error like the following: Under Windows 95, Visual FoxPro terminates on the SELECT statement with an error like the following: The address (either the 0x0044817c or 0137:00440940 in the preceding example) will vary with the specific Visual FoxPro 5.0x build number. The error does not occur in Visual FoxPro 3.0x and one record is returned. WorkaroundAdding the IN clause prevents the error from occurring. Here is a possible work around for this problem:
(c) Microsoft Corporation 1998, All Rights Reserved. Contributions by Jim Saunders, Microsoft Corporation Additional query words: kbvfp500bug kbVFp500abug kbSQL kbvfp600fix kbdse kbcode
Keywords : kberrmsg |
Last Reviewed: February 9, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |