What you can do – PB Docs 2018

• Allow updates in a DataWindow object associated with
  multiple tables or a view; you can define one of the tables as
  being updatable

• Prevent updates in a DataWindow object associated with one
  table

• Prevent updates to specific columns in a DataWindow object
  that is associated with an updatable table

• Specify which columns uniquely identify a row to be
  updated

• Specify which columns will be included in the WHERE clause
  of the UPDATE or DELETE statement PowerBuilder generates to update
  the database

• Specify whether PowerBuilder generates an UPDATE statement,
  or a DELETE then an INSERT statement, to update the database when
  users modify the values in a key column

Updatability of views

Some views are logically updatable; some are not. For the
rules your DBMS follows for updating views, see your DBMS
documentation.

To specify update characteristics for a DataWindow
object

1. Select Rows>Update Properties from the menu bar.

   The Specify Update Properties dialog box displays.

2. To prevent updates to the data, make sure the Allow Updates
   box is not selected.

3. To allow updates, select the Allow Updates box and specify
   the other settings as described below.

4. Click OK.