RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TIBBatchMove.ProblemTableName Property

Specifies the name of a Interbase 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.

Pascal
property ProblemTableName: TFileName;
C++
__property TFileName ProblemTableName;

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 TIBBatchMove 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.
 

 

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!