Auto-Update Tab, CursorAdapter Builder

Specifies how the CursorAdapter object automatically updates records in the data source. For more information about CursorAdapter objects, see CursorAdapter Class.

• Send updates
  Specifies whether the CursorAdapter object is available for updating. Send updates is selected by default.

• Auto-update
  Specifies whether to enable automatic updating capability for the CursorAdapter object.

• Advanced
  Displays the Advanced Update Properties dialog box, which contains four tabs: Update, Delete, Insert, and Conflict.

  The Update, Delete, and Insert tabs allow you to specify the following information:

  • Allow (update/delete/insert)

    Specifies whether to permit the update, delete, or insert operation. This option is selected by default.

  • Update/Delete/Insert command

    Specifies a custom update/delete/insert command text. These commands can be SQL UPDATE/ DELETE/INSERT statements, stored procedure names, calls to custom methods or procedures, and so forth.

  • Update data source type

    Specifies an appropriate data source type if you need a different data source type for your Update/Insert/Delete commands.

    Note

    When you select ADO or ODBC, you must also enter data source information as specified on the Properties tab.

  The Conflict tab allows you to specify the following information:

  • Conflict check type Specifies how to handle conflict checking during an update or delete operation. For more information, see ConflictCheckType Property.

  • Conflict check command Specifies a custom command to use for checking update or delete conflicts. For more information, see ConflictCheckCmd Property.

• Refresh
  Displays the Refresh Properties dialog box, which contains four tabs: Record Refresh, Fields Refresh, Refresh After Insert, and Refresh After Update.

  The Record Refresh tab allows you to specify the following information:

  • Refresh command Specifies the command to use for the record Refresh performed by the RecordRefresh Method. For more information, see RefreshCmd Property.

  • Refresh data source type Specifies the data source type used for the RecordRefresh method. Depending on the data source type selected, you can select or build a specific data source (see Properties Tab, CursorAdapter Builder for more details on these options). For more information, see RefreshCmdDataSourceType Property.

  The Fields Refresh tab allows you to specify the following information:

  • Refresh timestamp Specifies if the fields selected in the fields list are automatically refreshed when an Insert or Update command is executed. For more information, see RefreshTimeStamp Property.

  • Fields list Specifies a list of fields that are ignored by the refresh process when the RecordRefresh Method is executed. For more information, see RefreshIgnoreFieldList Property.

  The Refresh After Insert/Update tabs allow you to specify the following information:

  • Insert/Update refresh command Specifies the command to automatically refresh the record after an Insert/Update command is executed. For more information, see InsertCmdRefreshCmd Property and UpdateCmdRefreshCmd Property.

  • Fields list Specifies the fields in the cursor to refresh after an Insert/Update command is executed. You can also specify key fields used. For more information, see InsertCmdRefreshFieldList Property, InsertCmdRefreshKeyFieldList Property, UpdateCmdRefreshFieldList Property and UpdateCmdRefreshKeyFieldList Property.

  • Refresh all fields Enables all fields in the list to be refreshed.

• Tables
  Specifies a comma-delimited list of tables for updating. The builder usually supplies the table list.

• Key field column (key symbol)
  Displays check boxes for selecting primary key fields. This column is available only when Auto-update is selected.

• Automatic updating column (pencil symbol)
  Displays check boxes for selecting fields for automatic updating. This column is available only when Auto-update is selected.

• Cursor field
  Displays the fields available for automatic updating. This column is available only when Auto-update is selected.

• Update name
  Specifies the field names, as tableName.FieldName, used for automatic updating. This column is available only when Auto-update is selected. For more information, see UpdateNameList Property.

• Update all fields
  Specifies that all fields are selected and updated automatically. You must still specify a key field.

• Update using
  Specifies the preferred update method: SQL UPDATE or SQL DELETE then INSERT. For more information, see UPDATE - SQL Command, DELETE - SQL Command, and INSERT - SQL Command.

• SQL WHERE clause includes
  Specifies the type of WHERE clause used for updating: key fields only, key and updatable fields, key and modified fields, or key and timestamp. For more information, see the WhereType property.

• Batch update count
  Sets the BatchUpdateCount property value. For more information, see BatchUpdateCount Property.

• Compare memo
  Sets the CompareMemo property value to either on or off. For more information, see CompareMemo Property.

• Use transactions
  Specifies if the CursorAdapter uses transactions when sending Insert, Update or Delete commands through ADO or ODBC. For details, see the UseTransactions Property.

• Timestamp fields
  Specifies the timestamp fields in the cursor. For details, see the TimestampFieldList Property.

• Conversion functions
  Specifies a comma-delimited list of field name and function name pairs separated by spaces. For details, see the ConversionFunc Property.

• UpdateGram schema
  Specifies the mapping schema name and location passed to the XMLUPDATEGRAM( ) function. This setting applies only when the CursorAdapter DataSourceType is "XML". For details, see the UpdateGramSchemaLocation Property.

See Also

Reference

CursorAdapter Builder
Data Access Tab, CursorAdapter Builder
Properties Tab, CursorAdapter Builder