Working with the Edit Table Dialog Box - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Working with the Edit Table Dialog Box

When the Edit Table dialog box first appears it is in read-only mode. To enter edit mode, do one of the following:

  • Double-click the cell to edit.
  • Navigate to the row to edit and press Enter to enter edit mode for the first column in the row. Press Tab to move to other cells in the row.
  • After editing a cell you can do the following:

     

    Click or press

    To

    Enter

    To accept the new value and exit Edit mode

    Tab

    To accept the new value and edit the next cell

    Esc

    Revert to the old value and exit Edit mode

    Mouse button

    To accept the new value and exit Edit mode

    Note: In many cases you cannot exit edit mode if you enter a value that is invalid for the underlying data type. If this occurs, either correct the value or press Esc to revert to the original value.

    After a value has been changed, the Update and Revert buttons are enabled and the background color of the row changes. The default color is gold, but it can be changed using the Code Editor tab of the Options dialog box.

    After making all changes, press Update to apply them to the underlying table. If all changes are successful the background color of the updated rows revert to normal. If any row(s) fail to update due to table constraints and so forth, an error message appears and those rows retain their changed background. Click on each row to display a message indicating the error that occurred.

    If you try to edit a character value whose column is defined as larger than 80 characters or whose value contains a carriage return, the Edit Text Cell dialog box appears.

    1 Double-click or press Enter to enter Edit mode.

    The Edit Text Cell dialog box appears with the text shown in a multi-line text box.

    2 Make your changes to the text, then press Save to accept the change or press Cancel to discard the change.

    1 Double-click the ‘Insert’ row to enter Edit mode.

    The Insert row is immediately below the column titles, indicated by an asterisk in the left margin and a pale cream (default) background.

    2 Enter a value for each non-Null column.

    As soon as you exit edit mode, the new row moves down to the main grid area and the top row becomes available for adding another row. Newly added rows also display the changed background color until the Update button has been pressed.

    1 Select the rows to be deleted.

    2 Right click and press Delete Rows.

    3 Click Yes when asked for delete confirmation.

    The deleted rows immediately disappear from the grid but are not removed from the underlying table until Update is pressed.

  • Press the Revert button.
  • The data is reloaded from the underlying table and all rows revert to the default background color.