You can change DataWindow update settings to:
Allow updates in a DataWindow object associated with multiple tables or a view, and 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 PocketBuilder generates to update the database
Specify whether PocketBuilder 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.
Changing tab values
PocketBuilder does not change the tab values associated with
columns after you change the update characteristics of the DataWindow
object. If you have allowed updates to a table in a multitable DataWindow
object, you should change the tab values for the updatable columns
so users can tab to them.
For more information, see “Defining the tab order in a DataWindow object”.
To specify update characteristics for a DataWindow
object:
Select Rows>Update Properties from the menu bar.
The Specify Update Properties dialog box displays.
To prevent updates to the data, make sure the Allow Updates box is not selected.
To allow updates, select the Allow Updates box and make changes as required to the update settings by:
Click OK.
