Filter
Top Products
DataWindow Designer User’s Guide 191
CHAPTER 6
Controlling Updates in
DataWindow Objects
About this chapter
When DataWindow Designer generates the basic DataWindow object, it
defines whether the data is updatable. This chapter describes the default
settings and how you can modify them.
Contents
About controlling updates
When DataWindow Designer 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, DataWindow Designer 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, DataWindow Designer 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.
Topic Page
About controlling updates 191
Specifying the table to update 193
Specifying the unique key columns 193
Specifying an identity column 194
Specifying updatable columns 194
Specifying the WHERE clause for update/delete 195
Specifying update when key is modified 197
Using stored procedures to update the database 198