Allow Updates

Check to specify that data is updateable. By default, updates are
only allowed if the DataWindow object contains columns from a single table
and includes the table’s key columns.

Table to Update

If the DataWindow object contains columns from multiple tables,
specify the table that can be updated using the DataWindow object.

Where Clause for Update/Delete

Specify which columns are included in the WHERE clause.

Select Key Columns only with a single-user database or if
you are using database locking.

Key Modification

Specify which SQL statements are generated when a column specified
in the Unique Key Column(s) box is changed. Use DELETE then INSERT
if your DBMS does not allow users to modify two keys and set a value
in one row to the original value of the other row, or if your DBMS
has an Insert trigger.Use UPDATE if only one row can be modified
before the database is updated.

Updateable Columns

Click a column to toggle highlighting. Highlighted columns
can be updated. If you make a column updateable, make sure its tab value
in the workspace is a non-zero number so that users can tab to it.

Unique Key Column(s)

Specify columns that uniquely identify the row to be updated.
The default is the primary key(s).

Primary Key

Click to cancel changes in the Unique Key Column(s) box and specify
the primary key(s) instead.

Identity Column

Specify an identity column. An identity column is one whose
value in a new row is automatically assigned by the DBMS. If an identity
column is specified, PowerBuilder displays its value for a new row after
an insert in the DataWindow object.