SELECT - SQL Command - Additional Display Options

You can specify additional display options for the final query results from a SQL SELECT statement.

For the complete syntax, see SELECT - SQL Command.

The detailed syntax for the Additional Display Options is as follows:

[PREFERENCE PreferenceName] [NOCONSOLE] [PLAIN] [NOWAIT]

Parameters

• [PREFERENCE PreferenceName]
  Saves the attributes and options of the Browse window for later use when query results are sent to a browse window.

  Note

  You can retrieve preferences at any time. The attributes, or preferences, are saved indefinitely in the FoxUser.dbf resource file.

  The first time you use the PREFERENCE clause in a SELECT statement, it creates the preference. Issuing a SELECT statement later with the same preference name restores the Browse window to that preference state. When the Browse window is closed, the preference is updated. If you close a Browse window by pressing CTRL+Q or CTRL+W, changes you made to the Browse window are not saved to the resource file.

• [NOCONSOLE]
  Prevents display of query results sent to a file, the printer, or the main Visual FoxPro window.

• [PLAIN]
  Prevents column headings from appearing in the query output that is displayed.

• [NOWAIT]
  Continues program execution after the Browse window is opened and query results are directed to it. The program does not wait for the Browse window to close but continues execution on the program line immediately following the SELECT statement.

  Note

  If an INTO clause is included, Visual FoxPro disregards the NOWAIT option.

  For example, when you include the TO SCREEN clause to direct output to the main Visual FoxPro window or to a user-defined window, output pauses when the main Visual FoxPro window or user-defined window is full of query results. To see the next set of query results, press a key. However, if you include NOWAIT, the query results scroll off the main Visual FoxPro window or the user-defined window without pausing for a key press.

Remarks

The following code shows a summary of the main clauses of the SELECT - SQL Command:

SELECT Select_List
   FROM Table_List
...[WITH (BUFFERING = lExpr)]
   [WHERE Conditions]
   [GROUP BY Column_List]
   [HAVING Conditions]
   [UNION Clause]
   [ORDER BY Column_List]
   [INTO Clause | TO Clause ]
   [Additional_Display_Options]

For more information about a particular clause of the SQL SELECT command, see the following topics:

• SELECT Clause

• FROM Clause

• SELECT - SQL Command - WITH Clause

• SELECT - SQL Command - WHERE Clause

• GROUP BY Clause

• HAVING Clause

• UNION Clause

• ORDER BY Clause

• INTO or TO Clause

• Additional Display Options

See Also

Reference

CREATE QUERY Command

CREATE TABLE - SQL Command

MODIFY QUERY Command

Other Resources

Working with Queries

Working with Views (Visual FoxPro)

Query and View Designers