FIX: "SQL Column Not Found" Error Causes Transgressed HandleLast reviewed: October 14, 1997Article ID: Q108714 |
2.50 2.50a 2.50b | 2.50
WINDOWS | MS-DOSkbprg kbfixlist kbbuglist kberrmsg The information in this article applies to:
SYMPTOMSIn FoxPro 2.5, 2.5a, and 2.5b for Windows and FoxPro 2.5 for MS-DOS, if you have a calculated field in a BROWSE that calls a user-defined function (UDF), and the UDF performs an SQL SELECT command with a nonexistent column name, you correctly get the "SQL Column Not Found" error. If you choose the Cancel button, the program closes, but if you choose the Ignore button, you get dumped out of the program with a "Use of transgressed handle" error message in FoxPro for MS-DOS or a general protection (GP) fault in FoxPro 2.5 for Windows. In FoxPro 2.5a and 2.5b for Windows, the program enters a continuous loop until you select another option.
STATUSMicrosoft has confirmed this to be a problem in FoxPro versions 2.5, 2.5a, and 2.5b for Windows and FoxPro 2.5 for MS-DOS. This problem was corrected in FoxPro 2.5a for MS-DOS and in FoxPro 2.6 for Windows. In FoxPro versions 2.5a and later for MS-DOS, you will be able to continue the program when you choose the Ignore button.
MORE INFORMATION
Steps to Reproduce ProblemThe following program demonstrates the problem:
*Test.prg USE (SYS(2004)+"FoxHelp") AGAIN BROWSE FIELDS Topic, Details, Class,; KaBoom=KaBoom(ALIAS()) RETURN && won't get this far FUNCTION KaBoom PARAMETERS lcTopic * Column BogusCol does not exist. SELECT BogusCol FROM FoxHelp INTO ARRAY aTemp; WHERE Topic = m.lcTopic *RETURN IIF(_TALLY==0, "", aTemp[1]) && FoxPro has an * "insufficient memory" error if using this line - after * "not defined" error RETURN IIF(_TALLY==0, "", "something") && FoxPro will GPF on this line ** end |
Additional reference words: FoxDos FoxWin 2.50 2.50a 2.50b buglist2.50
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |