SQLMemTable: BDE Alternative Embedded
In-Memory Database with SQL for Delphi / C++Builder



Specifies the name of an Accuracer 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. This table will be created in the database to which Destination table belongs.

Delphi syntax:

property ProblemTableName: String;

C++ syntax:

__property AnsiString ProblemTableName = {read=FProblemTableName, write


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

© AidAim Software SQLMemTable: In-memory Sql Database Delph