Partition

Select a partition name from the drop-down.

Read data in batches

Specify the number of rows in the Rows field, to be retrieved from the database and stored by the client. The default value is 200.

Rebuild dataset on Reposition

Select to rebuild the temp-table starting with the specified record.

Open query on initialization

Select to open the query when the SmartDataObject initializes. This check box is selected by default.

Instance name

The identifier of this object instance, used by SmartBusinessObjects and in similar contexts to distinguish one SmartDataObject from another. The default value is the filename root without the file path and extension. You can change it to some other value.

Check current changed

Select to check on update that records in the database have not been changed since they were retrieved by this instance of the SmartDataObject.

Activate/deactivate DataTargets on view/hide

Defines whether or not the SmartDataObject retrieves records needed by objects that are currently hidden.

Prompt on delete

Select to display confirmation prompt for record deletions.

Display fields for prompt

Select which field values display when prompting to confirm record deletions.

Select any one of the following options:

Edit display field list

Opens the Multi-Field Selector dialog which allows you to select the fields. The selected field values are displayed for record deletion prompts.