SELECT-SQL NOCONSOLE Clause Description Clarification

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.

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

Keywords          : FxprgSql 
Version           : 2.60a  | 2.60a   | 2.60a     | 2
Platform          : MACINTOSH MS-DOS UNIX WINDOWS