AnyDAC
ContentsIndexHome
PreviousUpNext
TADCustomManager.GetGeneratorNames Method

Populates a string list with the names of generators / sequences / <how else> in a database.

Group
Links
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!