About controlling updates
When PowerBuilder generates the basic DataWindow object, it defines whether
the data is updatable by default as follows:
-
If the DataWindow object contains columns from a single
table and includes that table’s key columns, PowerBuilder defines
all columns as updatable and specifies a nonzero tab order for each
column, allowing users to tab to the columns. -
If the DataWindow object contains columns from two or more
tables or from a view, PowerBuilder defines all columns as not being updatable
and sets all tab orders to zero, preventing users from tabbing
to them.
You can accept the default settings or modify the update characteristics
for a DataWindow object.
If using a Stored Procedure or External data source
If the data source is Stored Procedure or External, you can
use the GetNextModified method
to write your own update script. For more information,
see the DataWindow Reference.