Modify Database Data
Table Data Viewer can be used to modify data in a database. The user must be granted update or write permissions on the database server.
Table Data Viewer Example
Insert a Database Record
Click on the Insert button from Table Data Viewer.
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 'Report' record
Click Close when done inserting records. The data grid in Table Data Viewer will automatically refresh.
Update a Database Record
In Table Data Viewer 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.
Table Data Viewer will automatically refresh.
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. Click Yes to proceed with deleting the records.
Table Data Viewer will automatically refresh.
Note: A primary key must be defined in DbWrench in order to Update or Delete database records using Table Data Viewer for a given table.
See also: