Microsoft KB Archive/122359

{| = SELECT-SQL NOCONSOLE Clause Description Clarification =
 * width="100%"|

ID: Q122359

2.60a | 2.60a   | 2.60a     | 2.60 MS-DOS | WINDOWS | MACINTOSH | UNIX kbprg kbdocerr The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, versions 2.6a
 * Microsoft FoxPro for Windows, versions 2.6a
 * Microsoft FoxPro for Macintosh, version 2.6a
 * Microsoft FoxPro for Unix, version 2.6

SUMMARY
The Language Reference manual text on the NOCONSOLE clause of the SELECT-SQL states:

Including NOCONSOLE prevents the query results from being displayed on  the desktop or main FoxPro window. NOCONSOLE can be used whether or not a TO clause is present. If an INTO clause is included, NOCONSOLE is  ignored. In fact, if neither the TO or INTO clause is included, the results of the query are displayed in the form of a browse window. If the TO clause is used, NOCONSOLE is effective, even overriding a "TO Screen" clause. If the user doesn't need an "INTO" and doesn't want the query results displayed on the screen he or she can use the combination of "TO Screen" and "NOCONSOLE" to achieve a non-display of results.

If the INTO clause is used, such as "INTO Cursor Mycursor" or "INTO Table temp.dbf," the results of the query will not be displayed on the screen whether or not the NOCONSOLE clause is used.