If the DataWindow contains columns from a single database table, the DataWindow Painter assumes that all columns are updateable.  If the DataWindow contains columns from two or more database tables, the DataWindow Painter assumes that no columns are updateable.

To control updates in a DataWindow, use Update on the Rows Menu to create Update Characteristics for the DataWindow.  You can:

Prevent updates to specific columns in a DataWindow that is associated with one database table.

Allow updates in a DataWindow that is associated with multiple database tables and control the columns that can be updated.

In addition, you can use this menu item to specify the SQL syntax you want PowerBuilder to generate to update the database with changes in the DataWindow. 

TIP:      Use Test on the Design Menu to test the update characteristics for a DataWindow.