SELECT-SQL NOCONSOLE Clause Description Clarification

 Last reviewed: November 21, 1995
Article ID: Q122359
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.

REFERENCES

Microsoft FoxPro for MS-DOS and Windows "Language Reference," Page L3-867 Microsoft FoxPro for Macintosh "Language Reference," Page 690

Additional reference words: NOCONSOLE SELECT 2.00 2.50 2.60 FoxDos FoxWin
FoxUnix FoxMac Commands Functions
KBCategory: kbprg kbdocerr
KBSubcategory: FxprgSql

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 21, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.