| **Navigation:**  [[templates.htm|Templates]] > Guide to all Templates > Control Templates >====== ADO Browse Update Button control template ====== | [[tplcontroladobrowseprocessbutton.htm|{{btn_prev_n.gif|Previous page}}]][[templates.htm|{{btn_home_n.gif|Return to chapter overview}}]][[tplcontroladoerrorlist.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

The ADO BrowseUpdateButtons template provides three buttons for managing ADO I/O for the ADO BrowseBox: Insert, Change, and Delete. These three button controls act on the records in a browse box. When pressed, the button retrieves the selected record and invokes the respective database action for that record.

The ADO BrowseUpdateButtons template provides the following prompts:

**Update Procedure**

Type a procedure name or select a procedure name from the drop-down list. If you type a new procedure name, the Application Generator adds the new procedure to the Application Tree.

**Procedure Parameters**

Allows you to specify parameter names (an optional list of variables separated by commas) for your update procedure, which you can pass to it from the calling browse procedure. You must specify the functionality for the parameters in embedded source code.

**Example:** (LOC:HideID,GLO:AccessLevel)

**Set UNIQUETABLE**

This checkbox will control the generation of code to set the value of UNIQUETABLE in the recordset for updating. If checkbox is set, this will enable the UNIQUEVALUE Value prompt.

**UNIQUETABLE Value**

Press the ellipsis button to select the UNIQUETABLE (default value is the Primary file).

**Generate a Resync statement**

Check this box to force the ADO templates to generate a RESYNC statement. Some back ends (e.g., Oracle) do not need this statement specified. The statement generated will correspond to the one generated for the ADO browse box with an additional WHERE clause in which the Columns that compose the primary key are included.

**Example:**   **SELECT * from Table where SysID = ?**

**Call Resync after update**

Check this box if the ADO recordset method RESYNC is called after an update. If set, the prompts **AffectRecords Parameter** and **Resync Values** parameter are enabled.

** **

**AffectRecords Parameter**

This prompt defines the value that must be set for the **AffectRecords** parameter of the RESYNC command. Default value is //adAffectAll//, but some back ends may only work with //adAffectCurrent// (e.g., Pervasive).

**Resync Values parameter**

This prompt defines the value that should be set for the **ResyncValues** parameter of the RESYNC command. Default value is //adResyncAllValues//.