Modify Database Data
The table's data viewer can be used to modify data in a database.
Table Data Viewer Example
Insert a Database Record
Click on the Insert button in Data tab.
A form will be dynamically generated for this table. Fill in the values for this table. When done, click the Insert button on this form.
GUI Form generated to insert a record
Click Close when done inserting records. The data grid will automatically refresh.
Update a Database Record
In table data tab select the row to update, and then click on the Update button.
A form will be dynamically generated for this table. The current values for this record will be loaded into form. Alter any values that should be updated. When done, click the Update button on this form.
Delete a Database Record
In Table Data Viewer select the rows to be deleted and then click the Delete button.
A confirmation dialog box will be displayed before the records are deleted.
Note: A primary key must be defined on a table in order to update or delete database records.
See also: