ADO: ActiveX Data Objects

Name

Recordset.Update Method — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     recordset.Update Fields, Values
                  

The Update method of the Recordset object saves the changes made to fields within the current record since a call to AddNew changes the contents of a field or array of fields.

Arguments

Fields (Variant or Variant array)

This argument can hold the field, ordinal position, array of fields, or an array of ordinal positions that you wish to update in the current record. The Fields argument must be of the same type and dimension as that of the Values argument.

Values (Variant or Variant array)

Optional. This argument can hold the value or values of the fields specified in the Fields argument. The Values argument must be of the same type and dimension as that of the Fields argument.

Description

The current record remains the current record after the call to the Update method.

If you specify an array of field names for the Fields argument to the Update method, the Values argument must have the same dimensional array passed to it, containing the corresponding values for each field listed in the Fields array. Otherwise, an error will be generated.

If you move to another record while editing a record, that record will be saved -- by an automatic call to the Update method -- before the record position is changed. In addition, if you are editing the current record and you call the UpdateBatch method, the Update method will again -- automatically be called.

Conversely, the CancelUpdate method cancels ...