Microsoft KB Archive/93336

{| = SELECT Without INTO Automatically Starts BROWSE =
 * width="100%"|

ID: Q93336

The information in this article applies to:


 * Microsoft FoxPro for Windows, versions 2.5 and 2.5a
 * Microsoft FoxPro for MS-DOS, versions 2.5 and 2.5a

SUMMARY
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.

MORE INFORMATION
The following two queries produce the same results in FoxPro version 2.5:

QUERY 1
SELECT * ; FROM CUSTOMER ; WHERE CUSTOMER.COMPANY = &quot;B&quot;

QUERY 2
SELECT * ; FROM CUSTOMER ; WHERE CUSTOMER.COMPANY = &quot;B&quot; ; 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 = &quot;B&quot; ; INTO CURSOR QUERY Additional reference words: FoxDos FoxWin 2.50 2.50a KBCategory: kbprg KBSubcategory: FxprgBrowse
 * }