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.
The detailed syntax for the Additional Display Options is as follows:
- [PREFERENCE PreferenceName]
Saves the attributes and options of the Browse window for later use when query results are sent to a browse window.
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.
Prevents display of query results sent to a file, the printer, or the main Visual FoxPro window.
Prevents column headings from appearing in the query output that is displayed.
You can use the PLAIN clause regardless of whether a TO clause is included. If an INTO clause is included, Visual FoxPro disregards the PLAIN option.
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.
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.
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: