|
RAD Studio (Common)
|
  |
   |
Command Text Editor
|
RAD Studio (Common)
|
|
|
Use this dialog box to construct the command text (SQL statement) for dataset components that have a CommandText property. The dialog buttons add SELECT and FROM clauses; other clauses (WHERE, GROUP BY, HAVING, ORDER BY, and so on) must be added manually to the SQL edit control.
|
Item |
Description |
|
Tables |
Displays the names of tables available in the current database. Select a table and click the Add Table to SQL button to add it to the command (SQL statement) displayed in the SQL edit control. |
|
Add Table to SQL |
Adds a SELECT clause for the table name selected in the Tables list to SQL edit box. |
|
Fields |
Displays the names of the columns available in the table currently highlighted in the Tables list. Select one or more columns and click the Add Field to SQL button to add it to the command (SQL statement) displayed in the SQL edit control. To select multiple columns, press CTRL and click the columns. To select a range of columns, press SHIFT and click the first and last columns in the range. |
|
Add Field to SQL |
Adds the columns selected in the Fields list to the SELECT clause. |
|
SQL |
Displays the command (SQL statement) for the CommandText property of the dataset or command component. This statement can be edited manually. |
|
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
|
|
What do you think about this topic? Send feedback!
|