To
edit data in a table:
Double-click the Table node in the tree.
Double-click the table you want to modify. The Schema page is displayed.
Click the Edit Data tab on top of the window. The Edit Data page is displayed.

To filter the data, click Filter. The Data Filter window will open where you can specify a WHERE condition.

Enter a condition by which the data is to be filtered and Click OK. The main window for the table is displayed.
Note: WHERE conditions must follow proper SQL syntax. See the section on Constraint Syntax at the end of this chapter for more information.
To update data,
Locate the data on the screen using the Page Up and Page Down buttons.
Click Modify.
Select the data on the screen.
Edit the data. If the column contains BLOB data, a pop-up menu will appear with the option to import, export, set null, or view. BLOB type columns allow content to be stored, FILE type columns give the option to store content (as a system file object) or store the file name (creating a user file object). Export allows the user to output BLOB or system file objects. Set null deletes the BLOB or file object. View opens the BLOB or file object in an application dependent on the view chosen.

Click Confirm. The data is edited in the selected table.
To delete data:
Locate the data on the screen using the Page Up and Page Down buttons.
Click Modify.
Select the data on the screen.
Click Delete.
Click Confirm. The data is deleted from the selected table.
Related topic: