Working with Results Grid
Result Grid has two modes: Results Display mode and Table Data Edit mode.
Results Display Mode
In Display query mode you can execute actions described below in a table. Generate SELECT/INSERT/DELETE/UPDATE for dates and string uses settings from Import / Export
Table Edit Mode
Table Data edit is entered when you select "Edit Table Data" from table popup menu in Object Pane. In this mode you can directly edit data in underlying table. When entering string values you do not need to enclose them in single quotes. To assign NULL value to a column leave content of cell empty. To enter empty string type two single quotes. Dates can be entered in any format which can be converted to date. If conversion to date fails nothing will be changed. Change in underlying table happens when you leave cell. At this point explicit COMMIT executed.
Grid popup menu actions
| Results in New Window | Display current results in a new window |
| Generate | |
| SELECT | Generates select statements for current selection |
| INSERT | Generates insert statement for current selection |
| UPDATE | Generates UPDATE statement for current selection. If table has unique constraint then will use it, otherwise will use selected columns in update clause |
| DELETE | Generates DELETE statement for current selection. If table has unique constraint then will use it, otherwise will use selected columns in delete clause |
| WHERE IN () | Generates WHERE IN statement for current selection |
| ORDER BY () | Generates ORDER BY statement for current selection |
| GROUP BY () | Generates GROUP BY statement for current selection |
| CREATE TABLE () | Generates CREATE TABLE statement based on current selection |
| Column Format | Allows to quickly change column display format |
| Filter | Allows to quickly filter rows based on a value in current cell |
| Get Child / Parent Rows | Allows to quickly retrieve Child / Parent rows rows based on a FOREIGN KEY constraint defined for selected rows |
| Find in Results | Find in Results |
| Copy | Copy selection to Clipboard. Data copied in two different formats |
| Copy With Column Name(s) | Same as above only includes column names |
| Copy Column Name(s) | Copy only column names to Clipboard |
| Export to Excel | Export selection to Excel |
| Export to File | Export selection to File |
| Results | Switch column and rows |
| Add Result Tab | Add new result tab if option Multiple Results Tabs enabled |
| Delete Result Tab | Delete current result tab |
| In Grid | Display query results in Grid |
| In Text | Display query results in Text |
| Transpose | Switch column and rows |
| Freeze Columns | Freeze columns to the left of current cell |
| Show Column Types | Display column type below header in Grid |
| Show Column Totals | Show total for numeric columns in current selection |
Notes
Generate feature by default copies generated statement to a current cursor position in Script Editor.
If you hold Ctrl key down when using generate then statement will be copied at the end of current script