AppCode 2018.3 Help


Add a row

  1. Click the Add New Row icon (The Add New Row icon) on the toolbar. Alternatively, right-click the table and select Add New Row from the context menu.

  2. Press ⌘N.

Delete a row

  1. Select the row or rows that you want to delete.

    Rows are selected by clicking the cells in the column where the row numbers are shown. To select more than one row, use mouse clicks in combination with the Ctrl key.

  2. Click the Delete Row icon (the Delete Row icon) on the toolbar. Alternatively, press ⌘⌫ or .

Clone a row

You can clone a selected row. The copy of the row is added to the end of the table.

To clone a row, right-click the row and select Clone. Alternatively, select the row and press ⌘D.

Depending on the value of the Limit page size to parameter, the result set might be divided into several pages. For example, you set the Limit page size to parameter to 100, but your query returned 200 rows. You will have two pages of rows, with 100 rows on each page. To navigate between pages, use the following controls:

  • The first page icon: Navigates to the first page of the result set.

  • The previous page icon: Navigates to the previous page of the result set. ( ⌥⌘↑ )

  • The next page icon: Navigates to the next page of the result set. ( ⌥⌘↓ )

  • Go to the last page icon: Navigates to the last page of the result set.

Making all rows visible simultaneously

If you want all the rows to be shown simultaneously:

  1. Click IconDBToolbarMenu on the toolbar and select Settings.

  2. Switch to the Database | Data Views page, specify 0 in the Result set page size field, and click OK.

  3. Click icons actions refresh svg or press ⌘R to refresh the table view.

See also, and Result set page size.

Go to the specified row

To navigate to a row with a specified number, right-click the table and select Go To | Row (⌘L). In the Go to row dialog, specify the row number and click OK.

Go to a specified row

Navigate to a related object

You can retrieve rows from the table for the selected object, and move the focus to the object. For example, select a field in the project tree and press ⌥⌘B. The focus moves to the corresponding column in the new tab.

To navigate to the object in the result set, select an object and go to Navigate | Related Symbol (⌥⌘B).

Navigate between related data

You can navigate between different types of related data:

  • Referenced data: data that is referenced by the current object.

  • Referencing data: data that is referencing the current object.

Referenced and referencing data
  1. Right-click the column in the table and navigate to Go To | Referenced Data (⌘B) or Go To | Referencing Data (⌥⌘B).

  2. If the Choose target pop-up window appears, select the table and what rows to show:

    • First Referencing Row: all rows in the table. The first row that references the current row is selected.

    • Referencing Rows Only: only rows that reference the current row.

  3. Press

Last modified: 28 March 2019