|
AnyDAC
|
Populates a string list with the names of generators / sequences / <how else> in a database.
|
Parameters |
Description |
|
const AConnectionName: string |
A connection name. |
|
const ACatalogName: string |
A catalog name. |
|
const ASchemaName: string |
A schema name. |
|
const APattern: string |
A LIKE pattern. |
|
AList: TStrings |
A list to fill. |
|
AScopes: TADPhysObjectScopes = [osMy] |
A object scopes. |
Call GetGeneratorNames to retrieve a list of generators / sequences / <how else> in a database.
AConnectionName is the connection name to use.
ACatalogName and ASchemaName restrict generator names to the catalog and schema.
APattern is the LIKE-pattern filtering generator names.
AList is a TStrings descendant that receives the generator names. Any existing strings are deleted from the list before GetFieldNames adds the names of generators.
AScopes restricts generator names to the specified scopes.
The generator names are normalized - enclosed into quotes, if that is required, otherwise converted to default dictionary case. Specify the MetaDefSchema and/or MetaDefCatalog parameters in connection definition, to avoid these schema and/or catalog names in generator names.
procedure GetGeneratorNames(const AConnectionName: string; const ACatalogName: string; const ASchemaName: string; const APattern: string; AList: TStrings; AScopes: TADPhysObjectScopes = [osMy]; AFullName: Boolean = True);
Querying Metadata, TADMetaInfoQuery, TADCustomConnection.GetGeneratorNames
ADManager.GetGeneratorNames('myconn', '', '', 'MY%', ListBox1.Items, [osMy, osSystem]);|
What do you think about this topic? Send feedback!
|