TADMapRule.NameMask Property

Specifies column name mask.

Group

published

Links

TADMapRule Class, TADMapRule Members, uADStanOption Namespace, Example 1, Example 2, published, See Also

Description

Use NameMask property to specify a mask to match the column names. The mask uses LIKE operator format, where:

'%' - many symbols;
'_' - one any symbol;
'\' - escape character.

If a column name matches a mask, then exactly this column matches to this map rule. And the column will get TargetDataType type. Other properties may be used to strict the rule.

Syntax

property NameMask: String;

Example 1

// maps all columns ending with ID to dtInt32
with ADQuery1.FormatOptions.MapRules.Add do begin
  NameMask := '%ID';
  TargetDataType := dtInt32;
end;

Example 2

// maps all ID columns of dtFmtBCD data type to dtInt32
with ADQuery1.FormatOptions.MapRules.Add do begin
  NameMask := 'ID';
  SourceDataType := dtFmtBCD;
  TargetDataType := dtInt32;
end;

What do you think about this topic? Send feedback!