Data.SqlExpr.TSQLSchemaInfo.Pattern
[–] Properties | |
---|---|
Type: field | |
Visibility: public | |
Source: Data.SqlExpr.pas Data.SqlExpr.hpp
| |
Unit: Data.SqlExpr | |
Parent: TSQLSchemaInfo |
Delphi
Pattern: string;
C++
System::UnicodeString Pattern;
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.