Specifications

Manipulating data
110 InfoMaker
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.
Sorting rows
You can sort the data, but any sort criteria you define are for testing only and
are not saved with the table or passed to the Report painter.
❖ To sort the rows:
1 Select Rows>Sort from the menu bar.
The Specify Sort Columns dialog box displays.