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 three tabs: Update, Delete, and Insert. Each tab allows 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.

• 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.
• Conversion functions
  Specifies a comma-delimited list of field name and function name pairs separated by spaces. For details, see the ConversionFunc Property.

See Also

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