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:
|
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. |
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. |
Icon | Tool Tip | Description |
---|---|---|
Top | Display the first, previous, next or last record. | |
Prior Row | ||
Next Row | ||
Bottom |
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
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. |
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. |
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. |
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. |
© ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center