Table and View Data

Use this form to view or edit table data within a database.

Access this form by selecting the Tables or Views node (within a database) in the navigation pane and clicking the open icon .

SQL Command
Shows the SQL command to retrieve the results.

Results Pane
Displays the results.

You can edit the results directly in the grid. When you are editing the leftmost column displays to indicate the record needs to be saved.

To save the record move to a new row in the grid or click the save icon .

To cancel the changes press ESC or click the undo icon .

BLOB Data
Allow you to view/edit images and other BLOB data within the table.

To view a column select the column name in the drop-down list.

To automatically update the display when you move between records click the refresh icon .

You can use the other icons to zoom, open files, save files and clear the data.