Data.SqlExpr.TSQLSchemaInfo.Pattern
Delphi
Pattern: string;
C++
System::UnicodeString Pattern;
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| field | public | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | TSQLSchemaInfo |
Description
Represents an SQL pattern mask that filters the resulting dataset.
Pattern uses the wildcards '%' (to match a string of arbitrary characters of any length) and '_' (to match a single arbitrary character). To use a literal percent or underscore in a pattern, the character is doubled (%% or __). If you do not want to use a pattern, set Pattern to nil (Delphi) or NULL (C++). The name of each item (table, stored procedure, field, parameter, or index) must match this pattern mask. If not, it does not appear as a record when the SQL dataset is opened.