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