Edit

Work on Data Grid

Select Multiple Cells

Supports :

This section explains how to select multiple cells on the data grid.

1. Connect to database.
2. On the main menu bar, go to File>New>SQL Editor. Or, simply click [SQL Editor] on the Toolbar or press Ctrl+N.
3. Write SQL.
4. Click [Run] or press F5.
5. On the data tab, check the query result.
6. Left-click and select multiple cells.

Operate Selected Cell

Supports :

This section explains how to operate selected cells on data grid.

1. Connect to database.
2. On the main menu bar, go to File>New>SQL Editor. Or, simply go to New Toolbar and click [SQL Editor] or press Ctrl+N.
3. Write SQL.
4. Click [Run] or press F5.
5. Check query result on data tab.
6. Left-click and choose more than one cells.
7. On status bar, check the number of selected columns and the result on the status bar

Note: It is set to get a sum as default. On the status bar, right-click and select count, count numbs, average, maximum value, and minimum value to display them alongside.

Copy Selected Cell

Supports :

This section explains how to copy selected cell on the data grid.

1. Connect to database.
2. On the main menu bar, go to File>New>SQL Editor. Or, simply click [SQL Editor] on the Toolbar or press Ctrl+N.
3. Write SQL.
4. Click [Run] or press F5.
5. On the data tab, check the query result.
6. Left-click and select multiple cells.
7. Right-click and select Copy>Copy Selected Cell.

8. Paste the copied cells or simply press Ctrl+V on the Editor window or other external editors.
9. Check the result.

Save Results as Excel

Supports :

This section explains how to save results in grid as an Excel file.

1. Connect to Database.
2. On the main menu bar, go to File>New>SQL Editor. Or, simply click [SQL Query Editor] on the New Toolbar or press Ctrl+N.
3. Write SQL.
4. Click Run or press F5.
5. On Data Tab, check query result.
6. Right-click and select Export Data>Excel File.
7. On Data Export window, select a file type to export data. Click [Next] and set file path and additional options. Click [Run].
8. Check the created file in Excel.

Fix the Selected Column

Supports :

This section explains how to fix a selected column on data grid.

1. Connect to database.
2. On the main menu bar, go to File>New>SQL Editor. Or, simply go to New Toolbar and click [SQL Editor] or press Ctrl+N.
3. Write SQL.
4. Click [Run] or press F5.
5. On data tab, check query result.
6. Right-click on a cell and choose [Pin Selected Column].
7. Check the result.

Sort Selected Columns

Supports :

This section explains how to sort selected columns on data grid.

1. Connect to database.
2. On the main menu bar, go to File>New>SQL Editor. Or, simply click [SQL Editor] or press press Ctrl+N.
3. Write SQL.
4. Click [Run] or press F5.
5. Check result on data tab.
6. Select a column and right-click. Then, click [Sort].

7. On the ‘Sort’ window, choose how to order columns and click [OK].

8. Check the result.

Here is the simple way to sort columns.

1. Left-click the column name.
2. Click [Yes] on the window.

3. Upon clicking the column name, columns will be arranged by biggest to smallest and vise versa.

View Data Horizontally/Vertically

Supports :

This section explains how to view data horizontally or vertically on data grid.

1. Connect to database.
2. On the main menu bar, go to File>New>SQL Editor. Or, simply click [SQL Editor] on the Toolbar or press Ctrl+N.
3. Write SQL.
4. Click [Run] or press F5.
5. Check query result on the data tab.
6. On the grid, right-click and select [Change Horizontal/Vertical View].
7. Check query result.

Add Column Name on the Editor

Supports :

This section explains how to add column name on the data grid.

1. Connect to database.
2. On the main menu bar, go to File>New>SQL Editor. Or, simply click [SQL Editor] on the Toolbar or press Ctrl+N.
3. Write SQL.
4. Click [Run] or press F5.
5. On the data tab, check the query result
6. Drag the column name to the editor.
7. The column name will be added to the editor.
8. Check the result.

Add/Modify Clipboard Data on the Grid

Supports :

This section explains how to get data from clipboard, add to the grid, and modify it.

1. Connect to database.
2. On the main menu bar, go to File>New>SQLEditor. Or, simply click [SQL Editor] on the New Toolbar or press Ctrl+N.
3. Write SQL.
4. On the main menu bar, go to Query>Run and Modify Current SQL. Or, click [Run and Modify Current SQL] on the Run Toolbar or press F6.

5. Check the result on the data tab.
6. Create data using separators on SQL Editor or other external editor.
7. Right-click and select data. Click [Copy] or press Ctrl+C to copy to clipboard.

8. Click [Add Record] on data tab navigator.

9. Right-click on cell and select [Paste] or press Ctrl+V.
10. On the clipboard window, click [Yes].
11. Check the result.

Auto-create IN syntax

Supports :

This section explains how to create IN syntax automatically on data grid.

1. Connect to database.
2. On main menu bar, go to File>New>SQL Editor. Or, simply click [SQL Editor] on the Toolbar or press Ctrl+N.
3. Write SQL query.
4. Click [Run] or press F5.
5. On data tab, see query result.
6. Right-click on a cell and click [Create IN syntax].

7. On main menu bar, go to Edit>Paste. Or, simply click [Paste] on the Toolbar or press Ctrl+V.
8. See the created IN syntax.