Auto-Update Tab, CursorAdapter Builder

JavaScript Editor js editor     Web development 



Main Page

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: The Fields Refresh tab allows you to specify the following information: The Refresh After Insert/Update tabs allow you to specify the following information:
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 CompareMemoproperty 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



JavaScript Editor js editor     Web development