SQL Query Results Data Grid
Browse the results of an executed SQL query in a dynamic grid with options for viewing, sorting and navigating. There can be multiple results displayed, one per statement executed. Each result set is displayed in a separate tab.
|
|
Note:
|
Rows Retrieved
| Icon | Tool Tip | Description |
|---|---|---|
 |
Count Dataset Rows | The value appears in bold in the Status bar at the bottom of the Code Editor window. |
| Fetch More | Retrieve more rows. | |
| Fetch All | Retrieve all rows. | |
 |
Stop Fetching | Use when it takes too long to fetch more/all rows. |
 |
Refresh Data | Populate the grid with the latest data. |
Export / Print
| Icon | Tool Tip | Description | ||
|---|---|---|---|---|
 |
Print Data Grid |
Print the SQL query results.
| ||
 |
Export Data |
Open the Export Data Dialog. |
|
|
TIP: Right click on the data grid to select a row or column or the entire data grid. You can copy selected data to the clipboard. There is an option to include the row number or column heading with the copied data. |
Browse
| Icon | Tool Tip | Description |
|---|---|---|
 |
Top | Display the first, previous, next or last record. |
 |
Prior Row | |
 |
Next Row | |
 |
Bottom |
Edit (Updateable Queries)
Turn ON Updateable in the SQL Editor Toolbar (Code Editor SQL) before you execute the SQL query. The status panel at the bottom of the Code Editor window says "Updateable" if the results can be edited. It says "Read Only" if the results cannot be edited.
|
|
TIP:
|
Requirements
- The SELECT statement must be a simple SELECT statement (no joins, subqueries in select clause, calculated fields, group by, having, count(), substr or DISTINCT). If you get an error message such as TOKEN:.(12121,2) then your query does not conform to the restrictions for updateable queries.
- You must have the appropriate privileges to update the table or view.
| Icon | Tool Tip | Description |
|---|---|---|
 |
Add Row | Insert a new row before the selected row. |
 |
Duplicate Selected Rows |
Duplicate the selected row(s). The duplicated data is highlighted in the grid until it is committed. |
 |
Delete Selected Rows | Put the cursor on the row you want to delete and click . |
 |
Commit Transaction | Save new or modified data to the database. |
 |
Rollback Transaction | Undo changes made to grid. |
Group Display
To create a group display, right click the data grid and select Group by this column.
| Icon | Tool Tip | Description |
|---|---|---|
 |
Cancel Grouping | Cancel the group display. |
Format
| Icon | Tool Tip | Description |
|---|---|---|
|
|
Default/User Defined Column Formatting |
User-defined column width. Overrides automatic column width setting. Drag the separators to set column width. |
|
|
Format Columns By Data Width |
Set the column widths to show the widest cell data. Column names may appear truncated. |
|
|
Format Columns By Name Width |
Set the column widths to show the widest column name. Table data may appear truncated. |
 |
Format Columns By Names And Data |
Set the column widths to show the widest column data or column name (whichever is greater). |
|
|
TIP: The formatted widths are based on the results currently visible. The column widths may change as you scroll down, retrieving new rows. To prevent the column widths from changing when scrolling, Fetch All rows before scrolling. |
Sort & Display
| Icon | Tool Tip | Description | ||
|---|---|---|---|---|
 |
Grid View |
Display multiple rows in a data sheet format
| ||
 |
Single Row View |
Display details of the selected record. | ||
 |
Expand Data Grid |
Maximize screen real estate of the data grid. | ||
|
Auto Refresh |
Select to refresh the SQL Results Data Grid every (number specified) seconds. |