View and edit data in the Card View mode

Card View mode

The Data Editor of the dbForge Transaction Log lets you view, edit, and print data in the Card View mode, where each data row (record) is represented as a card with a ‘Record N’ caption and number.

To view data in the Card View mode, click Switch to Card View on the Data Editor toolbar. To return to the Grid View mode, click Switch to Grid View on the Data Editor toolbar.

Card View

You can view or edit data in the same way as in the Grid View mode. Data cards can be expanded and collapsed with the corresponding control in the upper right corner of the card.

As opposed to the vertical scrolling of the Grid View mode, the Card View mode features horizontal scrolling.

Results output patterns

There are two patterns for the results output - Paginal mode and Infinite scrolling.

The Paginal mode splits data into pages and is used to display data with a large number of records.

Note

By default, the paginal mode displays 1000 records per page. You can specify any preferred number of records to be displayed per page on the Tools menu > Options > Data Editor > General.

If you turn off the paginal mode, the Infinite scrolling pattern will be activated, which loads data continuously as the user scrolls down the page and allows retrieving all data at once.

Note

If you want to retrieve all data from a table with a large number of records, you will get a message warning you about the possibility of the Out of memory exception. You can continue or cancel retrieving data or turn on the paginal mode.

Manipulate the results output

You can use a rich set of data management options from the shortcut menu.

Viewing data - shortcut menu

Note

Use Set Value To to set an empty string, zero, or the current date.

Refresh data

To refresh data, select Refresh on the Data menu (for the data view), from the shortcut menu, or on the toolbar. To abort an overly long refresh operation, select Stop Refresh on the Data menu (for the data view) or on the toolbar.

Sort cards

You can sort cards by column. To do this, go to the required column and use the sorting glyph to sort data in ascending or descending order.

To clear sorting on the current column, select Clear Sorting from the shortcut menu.

To print data, right-click a card and select Print, or press CTRL+P. The Preview window opens, where you can preview and adjust cards before printing. You can view thumbnails for each page, search for required data, customize printing options, open/save printing documents in the .prnx format, conduct page setup (format, width, height, orientation, and margins), add header and footer, zoom in and out, and quickly navigate across pages.

Printing - Preview window

Printing options can be configured on the Tools menu > Options> Data Editor > Print. Alternatively, right-click the card and select Options. In the window that opens, go to Data Editor > Print.

Customize the size of the cards

You can adjust the width and height of the cards. For this, in the Card View, click Customize.

Customize the size of the cards

Next, in the Layout View Customization dialog that opens, select the card and drag its bottom-right corner to change its size.

Drag the card

View and edit data in Data Viewer

You can view and edit data in the built-in Data Viewer. To open it, right-click the required cell in the grid and select Data Viewer. Alternatively, use the CTRL+W, R key combination. In the Data Viewer, you can save data to a file, copy/paste or cut data, view data in multiple formats, and make white spaces visible.

The Data Viewer toolbar has the following options:

Data Viewer toolbar

Save Data Save Data allows saving data to a file.

Copy Copy (Ctrl+C) allows copying data to the clipboard.

The following controls allow viewing data in multiple formats:

Hexadecimal View Hexadecimal View (Ctrl+1)

Text View Text View (Ctrl+2)

XML View XML View (Ctrl+3)

HTML View HTML View (Ctrl+4)

Web View Web View (Ctrl+5)

Rich Text View Rich Text View (Ctrl+6)

PDF View PDF View (Ctrl+7)

JSON View JSON View (Ctrl+8)

Image View Image View (Ctrl+9)

Fit Image View Fit Image (Ctrl+B)

Spatial View - Geometry Spatial View - Geometry (Ctrl+Alt+0)

View White Spaces View White Space makes white spaces visible.e.

Word Wrap Word Wrap adjusts the display of long text within cells or columns. When it is activated, the text automatically wraps onto the next line, making all the content visible within the cell’s width.

Note

Some queries return read-only data, for example, queries with aggregate functions (count, avg etc.) or data retrieved from non-updatable views. Such data cannot be edited. It is also impossible to edit the result of executing the script with several select statements.

Edit data in Data Editor

When the dbForge tool executes a statement, the retrieved data is displayed in the same SQL document in Data Editor.

The Data Editor toolbar has the following controls:

Data Editor toolbar

Refresh data Refresh Data and Stop Refresh Data allow you to refresh data and stop refreshing it in the grid, respectively.

Cached Updates Mode Cached Updates Mode allows you to apply data updates in a single batch, thus emulating a separate transaction. If this mode is activated, your data changes will be stored locally on the client side until you click Apply Changes. If there is no need for the changes to be applied, click Cancel Changes. If you close a document with Cached Updates Mode activated, all the changes made since the latest Apply Changes command will be canceled.

Paginal Mode Paginal Mode allows switching to the paginal mode.

Switching between pages Go to First Page / Go to Previous Page /Go to Next Page/ Go to Last Page allows switching between pages and specify the number of records per page.

Grid and Card View modes Switch to Grid View and Switch to Card View allows switching between Grid View and Card View.

Show Group by Box Show Group by Box allows grouping data by column.

Switching from read-only This menu allows switching from the read-only mode to editing.

Customize Customize: Customize the column display in cards. In the LayoutView Customization window that opens, you can drag the elements from the Hidden Items section to the Template Card and then preview the changes on the View Layout tab. In addition, the View Layout tab allows sorting or filtering data in the card mode by clicking the corresponding options next to the specific column. To save the changes, click OK. To apply the changes immediately, click Apply. To discard the changes, click Cancel.

Under the cards, you have the following options:

Data Editor toolbar

Records: These controls let you navigate down the card one record at a time, or instantly get to the first or the last record in the card.

Append and delete: These controls let you append or delete records from the card.

Apply or cancel changes: These controls let you apply or cancel changes made during editing.

Note

If you are editing data in a table with a foreign key, you can view the data of the related table using the foreign key lookup feature directly in Data Editor.

The data of the related table is shown after you click next to the field you want to edit. The corresponding record in the related table will be highlighted.

Select data

To select data, do one of the following actions:

  • Move the mouse pointer across the required cards holding the left mouse button.
  • Click the first card of the required data range, press and hold SHIFT, and then select the last card.
  • Use CTRL+A to select all cards.

Using the CTRL key can help you include/exclude cards from selection.

Copy and paste data

To copy the selected data, right-click it and do the following:

  • Select Copy on the shortcut menu or press CTRL+C to copy data.
  • Select Copy With Headers on the shortcut menu or press CTRL+SHIFT+C to copy data with headers.
  • Select Copy Data As on the shortcut menu to Copy Column Names Only or Copy Column Names and Types.

To paste data, select Paste or Paste As New Records on the shortcut menu or press CTRL+V.

Insert and delete data

For these operations, you can use the shortcut menu or the corresponding controls under the cards. For example, you can do the following:

  • To insert NULL (instead of an empty string), select Set Value To > Null from the shortcut menu. Alternatively, press CTRL+0.

Note

Use the Set Value To menu to quickly set an empty string, zero, or the current date.

  • To add a new record, select the Append option from the shortcut menu or click + under the cards.

  • To delete a record from the card, select the Delete option from the shortcut menu or click - under the cards. Alternatively, press CTRL+DEL.

Note

Some queries return read-only data; for example, queries with aggregate functions (e.g. COUNT, AVG) or data, retrieved from non-updatable views. Such data cannot be edited. It is also impossible to edit the results of multiple SELECT statements.

Row and cell indicators

When working with the cards, you can see special indicators next to the focused cell. These indicators reflect the current editing state.

Focused row The row is focused.

Editing The row is being edited.

Row edited The row has been edited.

Invalid value An invalid value has been entered into a cell. You must either enter a valid value or press the ESCAPE key to cancel changes.