SELECT Without INTO Automatically Starts BROWSEID: Q93336 The information in this article applies to:
SUMMARYWhen a SELECT command has no INTO clause, FoxPro places the selected data in a cursor named QUERY and automatically starts the BROWSE command so you can to view the output. You can prevent this behavior from occurring by specifying a cursor name in the SELECT command's INTO clause. MORE INFORMATIONThe following two queries produce the same results in FoxPro version 2.5: QUERY 1SELECT * ; FROM CUSTOMER ; WHERE CUSTOMER.COMPANY = "B" QUERY 2SELECT * ; FROM CUSTOMER ; WHERE CUSTOMER.COMPANY = "B" ; INTO CURSOR QUERY BROWSE NOMODIFY NOTE: Even though the following example places the data that meets the selection criteria into the QUERY cursor, it does not call the BROWSE command: SELECT * ; FROM CUSTOMER ; WHERE CUSTOMER.COMPANY = "B" ; INTO CURSOR QUERY Additional reference words: FoxDos FoxWin 2.50 2.50a KBCategory: kbprg KBSubcategory: FxprgBrowse |
Last Reviewed: June 27, 1995 |