From RAD Studio API Documentation
Jump to: navigation, search


property ProblemTableName: TFileName read FProblemTableName write FProblemTableName;


__property System::Sysutils::TFileName ProblemTableName = {read=FProblemTableName, write=FProblemTableName};


Type Visibility Source Unit Parent
property published
Bde.DBTables TBatchMove


Specifies the name of a Paradox table that will be created to contain all records from the Source that contain fields which were trimmed to match the corresponding field type in the Destination table.

Set ProblemTableName to create a table that holds records from the Source that contain fields that had to be trimmed to be applied to the Destination. ProblemCount will have the number of records placed in the new table. If ProblemTableName is not specified, the data in the record is still trimmed when applied to the destination table, but there will be no easy way to tell which fields were trimmed.

Trimming a field means converting its value to a value compatible with the destination field type. For example, if a field in the destination table holds a string of size 10 characters, and the corresponding field in the source table holds a string of size 15 characters, any values from the source table longer than 10 characters must be truncated. Values that cannot be converted will cause TBatchMove to raise an exception.

Trimming does not occur when the Mode property is set to batCopy. Trimming fields on a delete operation means that records in the destination table may be deleted that do not exactly match the values from the source table.

Note: If AbortOnProblem is true, then there will be at most one record in this table because the operation aborts with the first record that has a problem.

See Also