Data.SqlExpr.TSQLSchemaInfo.Pattern

From RAD Studio API Documentation
Jump to: navigation, search

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.

See Also