About the Grid Pane
See Also
The grid pane,the second pane in the
Visual SQL Editor, displays the columns in the query and allows you to specify query criteria for each column.
Some things you can do with columns in the grid pane:
- View the columns in the query and the table each column belongs to.
- Enter an alias for a field in the Alias field.
- Add columns to the query by selecting the Output column or remove columns from the query by clearing the Output column. Once you remove a column, you must select the column in the diagram pane or modify it in the SQL pane to add the column back to the query.
- Sort the fields in a column by selecting the Sort Type and specifying the Sort Order.
- Add criteria to a column by right-clicking on the column and choosing Add Query Criteria.
Changes you make to the query appear in the diagram pane and SQL pane.
- If the SQL query contains code that is not supported by the diagram pane,
the diagram pane becomes blank, but you might still be able to execute the query.
- See Also
- About Components and Data
About the Visual SQL Editor
Supported SQL Queries
Legal Notices