Updates one rowset or table from another by updating existing rows and adding new rows.

Syntax

<oRef>.appendUpdate( )

<oRef>

The UpdateSet object that describes the update.

Property of

UpdateSet

Description

Use appendUpdate(†) to update a rowset, allowing new rows to be added. You must specify the UpdateSet objectís indexName property which will be used to match the records. The index must exist for the destination rowset. The original values of all changed records will be copied to the table specified by the updateSetís changedTableName property.

To update existing rows only, use the update(†) method instead. To always add new rows, use the append(†) method.

When updating multiple rows, be sure the destination and source table structures are exact matches. If the table structures are not exact matches, appendUpdate( ) will terminate when it encounters the discrepency.