Update Tab for Multi-row Query
Use the Update tab to specify the how you want the rows updated in the database.
Page 1 Settings
Auto commit
Select Auto commit to have changes automatically committed to the database.
Defer updates
Select Defer updates if you do not want changes sent immediately to the database.
Lock row on edit
Select Lock row on edit to have the row of the database locked when the user is editing it (i.e. it is the current row).
Page 2 Settings
Columns to Update
The Columns to Update list shows all the columns you can update. Select from this list which columns of the database you want to update.
Columns to use as index
The Columns to use as index list shows the columns you can use as an index for locking and updating. You can use the Available push button to see actual indexes that are defined in the database. The columns that you choose should uniquely identify a row.
Last modified date: 01/29/2015