In this article:

Adding a Record

Changing Record Value

Navigating by Records

Refreshing Table Contents

Deleting the Current Record

Clearing Table

Editing Data

When working with table datasets, one can edit records of the following objects:

NOTE. If there is no primary key set for the table, on the first attempt to edit data the following message is displayed: Editing table without primary key or unique indexes may lead to data loss. To continue editing of table data, click the Yes button. To open the table in the view mode, click the No button.

Operations with data:

Adding a Record

To add a record as a new table row, click the Add Row button in the toolbar.

After executing one of the operations, a row is added to the table. Fill empty cells with data.

To save changes:

Changing Record Value

To change entire record value, select the table cell and set a new value using the keyboard.

To change part of record value, open the cell for edit by double-clicking on it.

After executing the operation the cell is opened for edit. Change record value.

Navigating by Records

To move along the tale records, use the mouse or cursor keys on the keyboard.

Refreshing Table Contents

To refresh table contents, click the Refresh Table Contents button on the toolbar.

After executing one of the operations table contents is refreshed. Data filtering on refreshing table contents is reset.

Deleting the Current Record

To delete the currently selected record, click the Delete Current Record button on the toolbar.

After executing one of the operations the selected record is deleted without operation confirmation.

Clearing Table

To clear the table and delete all records, click the Clear Table button on the toolbar.

After executing one of the operations the operation confirmation dialog box opens. If the answer is positive, the table is cleared.

See also:

Working with Table Data Set