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.
-
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.
-
Allow (update/delete/insert)
- 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.
-
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.
-
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.
-
Refresh command Specifies the command to use for the record Refresh performed by the RecordRefresh Method. For more information, see RefreshCmd Property.
- 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.