Key Properties

There are a number of new properties introduced with this component. The complete list of published properties is shown in Figure 5.16.

Property

Default Value

Purpose

AbortOnKeyViol

True

When True, the batch move operation j$ cancelled immediately when a key violation or integrity error is encountered. If False, the exception records are written to an alternate table.

146 ■ Part II—The Delphi Database Tools

Property

AbortOnProblem

Default Value Purpose

ChangedTableName

CommitCount

Destination

KeyViolTableName

Mappings

Mode

Name

ProblemTableName

RecordCount

Source

Transliterate

True batAppend

BatchMove I

The name of the source table for the batch operation.

This property is for the developer's use.

True

When True, the batch move operation is; cancelled immediately when data requires truncation to fit into the target table. If False, the data is truncated and the original problem rows are written to an alternate table.

This specifies the name of the table to which copies of all changed rows are written during the batch move ooeration.

The count of rows that are moved before a commit ooeration occurs..

The name of the destination table..

The name of the table to which key violation rows will be written.

This property contains the column-to-column mapping instructions between the source and target tables.

Determines the operation that occurs when a batch operation is executed.

The internal name of this component.

The name of the table to which problem rows will be written.

Determines the maximum number of [records that are applied to the destination table when the batch operation is executed.

The name of the source table for the batch operation.

This property is for the developer's use.

Determines if character translation is to occur during the batch operation.

Figure 5. 16 The TBatchMove component properties

Was this article helpful?

0 0

Post a comment