Microsoft KB Archive/93336
SELECT Without INTO Automatically Starts BROWSE
The information in this article applies to:
When 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.
The following two queries produce the same results in FoxPro version 2.5:
SELECT * ; FROM CUSTOMER ; WHERE CUSTOMER.COMPANY = "B"
SELECT * ; 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