Share via

Auto-Update Tab, CursorAdapter Builder

  • Article

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