Specifications

Users Guide 531
CHAPTER 19
Controlling Updates in Forms
About this chapter
When InfoMaker generates the basic form, it defines whether the data is
updatable. This chapter describes the default settings and how you can
modify them.
Contents
About controlling updates
When InfoMaker generates the basic form, it defines whether the data is
updatable by default as follows:
• If the form contains columns from a single table and includes that
table’s key columns, InfoMaker defines all columns as updatable and
specifies a nonzero tab order for each column, allowing you to tab to
the columns.
• If the form contains columns from two or more tables or from a view,
InfoMaker defines all columns as not being updatable and sets all tab
orders to zero, preventing you from tabbing to them.
You can accept the default settings or modify the update characteristics for
a form.
Data sources in the master/detail styles
The master/detail styles have a data source for the master area and a data
source for the detail area. Each of the data sources can be updatable.
Topic Page
About controlling updates 531
Specifying the table to update 533
Specifying the unique key columns 533
Specifying an identity column 534
Specifying updatable columns 534
Specifying the WHERE clause for update/delete 535
Specifying update when key is modified 537