Hint Sample Clauses

Hint. Zoom in/out of the chart using the mouse wheel to customize the time interval. Click and drag the chart left or right to change the time span. A Single Chart A Compared Chart

Hint. If you are importing from Access or ODBC, the Add Query and Modify Query buttons open the Add Query dialog where you can construct query to import only certain rows from your source tables. In other words, import only rows that satisfy the criteria set by you. Tables and queries will be shown in the Tables list. To delete a query, select it and click the Delete Query button. Choose Delimiter Specify the record separator of the file. Import the text file with delimited format.

Hint. Resize the suggestion list by dragging the lower right corner. You can enable or disable the code completion feature in Options. When you copy or cut some codes as usual in the editor, the copied content will also be added to Clipboard Stack. Clipboard Stack can store up to 10 items and use the last-in-first-out logic. To paste an item from Clipboard Stack, you can press CTRL+SHIFT+V. Press CTRL+SHIFT+V multiple times to cycle through Clipboard Stack. Code folding feature enables you to collapse blocks of code such that only the first line of the block appears in Query Editor. A block of code that can be folded is indicated by an icon to the left of the first line of the block. A vertical line extends from the icon to the bottom of the foldable code. In contrast, a folded block of code is indicated by an icon to left of the code block. You can fold the block by clicking or expand it by clicking . Navicat BI uses syntax highlighting which depending on the database associated with the query. Different databases have different sets of reserved keywords. You can configure the associated colors for different text fragments in Options. Navicat BI supports to highlight the matching brace in the editor, i.e. () .

Hint. Smart code-completion will pop up a list of variants for the word completion automatically. Brace Highlight

Hint. Click More Action and select Set Maintenance Window to set maintenance window for all selected instances.

Hint. Once uncheck the Show wizard next time option, you can go to Options to enable it. Function Designer is the basic Navicat tool for working with procedures/functions. You can enter a valid SQL statement in the Definition tab. This can be a simple statement such as SELECT or INSERT, or it can be a compound statement written using BEGIN and END. To customize the view of the editor and find out more features for SQL editing, see SQL Editor for details.

Hint. By default, the number of records showed is 1000. To show all records, click . To refresh the records, click or press F5. Click to open a pane on the left for showing a list of column names. Just simply click to show the additional column. To remove the columns, uncheck them in the same way. Hint: To set column in ascending or descending mode, right-click anywhere on the column and select Sort -> Sort Ascending / Sort Descending. Enter a search string into the Filter edit box and press ENTER to filter for the particular records. Data that being copied from Navicat goes into the Windows clipboard with the fields delimited by tabs and the records delimited by carriage returns. It allows you to easily paste the clipboard contents into any application you want. Spreadsheet applications in general will notice the tab character between the fields and will neatly separate the clipboard data into rows and columns. To select data using keyboard shortcuts CTRL+A Toggle the selection of all rows and columns in the data grid. SHIFT+ARROW Toggle the selection of cells as you move up/down/left/right in the data grid. To select data using mouse actions • Select the desired records by holding down the CTRL key while clicking on each row. • Select range of records by clicking the first row you want to select and holding down the SHIFT key together with moving your cursor to the last row you wish to select. • Select a block of cells. Note: After you have selected the desired records, just simply press CTRL+C or right-click it and select Copy. Paste Data into Grid View Data are copied into the clipboard will be arranged as below format: • Data are arranged into rows and column. • Rows and columns are delimited by carriage returns/tab respectively. • Columns in the clipboard have the same sequence as the columns in the data grid you have selected. When pasting data into Navicat, you can replace the contents of current records and append the clipboard data into the table. To replace the contents of current records in a table, you must select the cells in the data grid whose contents must be replaced by the data in the clipboard. Just simply press CTRL+V or right-click and select Paste from the pop-up menu. Navicat will paste all the content in the clipboard into the selected cells. The paste action cannot be undone if you do not enable transaction. To copy records as Insert/Update statement, right-click the selected records and select Copy As -> Insert Statement or Update Stat...

Hint. Resize the suggestion list by dragging the lower right corner. You can enable or disable the code completion feature in Preferences. When you copy or cut some codes as usual in the editor, the copied content will also be added to Clipboard Stack. Clipboard Stack can store up to 10 recent items and use the last-in-first-out logic. To paste an item from Clipboard Stack, you can press COMMAND-SHIFT-V. Press COMMAND-SHIFT-V multiple times to cycle through Clipboard Stack. Code folding feature enables you to collapse blocks of code such that only the first line of the block appears in the editor. A block of code that can be folded is indicated by an icon to the left of the first line of the block. A vertical line extends from the icon to the bottom of the foldable code. In contrast, a folded block of code is indicated by an icon to left of the code block. You can fold the block by clicking or expand it by clicking . Navicat Data Modeler supports to highlight the matching brace in the editor, i.e. () .

Hint. Position your cursor at the end of this document. On your keyboard press down on the Control key. While holding the Control key down, press the Enter key. A new page will appear.