Deriving Views › Using Views › Step 3: Changing Rows

Step 3: Changing Rows

Changes Made to Stored Table(s)

With the online application created for a view you can display the rows of the view and make changes to them. The changes are made directly to the stored tables from which the view is derived.

You Cannot Add or Delete Rows

You cannot add rows to a view or delete rows from a view; additions and deletions can be made only to stored tables.

For this sample application, change the value in the SALARY column. Press [PF2] to modify the source table in the database. Notice that the value of the SALARY DIFFERENTIAL column is recalculated when the row is modified.

You Cannot Make Join Criteria Untrue

When modifying data through a view, keep in mind that you cannot change an entry in a join column so that the join condition is no longer true. For example, in this sample application you cannot change the TITLE column because it must equal the POSITION APPLIED FOR column, which is not displayed.

ASF Processes Changes

Return to the Activity Selection screen ([PA1]) and access the JOB table (type job in the Table Name field and press [Enter]). Display the job that you just modified through the JOBS AND APPLICANTS view. Notice that the SALARY column reflects the change that you made through the view.