ADO Browse Update Button control template

Top  Previous  Next

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.