Filter
Top Products
CHAPTER 3 Managing the Database
DataWindow Designer User’s Guide 87
This window is in the grid format:
Only a few rows of data display at a time. You can use the First, Prior, Next,
and Last buttons to move from page to page.
Modifying data
You can add, modify, or delete rows. When you have finished manipulating the
data, you can apply the changes to the database.
If looking at data from a view
Some views are logically updatable and others are not. Some DBMSs do not
allow any updating of views.
For the rules your DBMS follows regarding updating of views, see your DBMS
documentation.
❖ To modify data:
1 Do one of the following:
• To modify existing data, tab to a field and enter a new value.
• To add a row, click the Insert Row button and enter data in the new
row.
• To delete a row, click the delete Row button.
When you add or modify data, the data uses the validation rules, display
formats, and edit styles that you or others have defined for the table in the
Database painter.
2 Click the Save Changes button or select Rows>Update to apply changes
to the database.