Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADMetaInfoQuery.BaseObjectName Property
TADMetaInfoQuery Class  TADMetaInfoQuery Members  uADCompClient Namespace  Example 1  Example 2  published  See Also  Send Feedback

Gets / sets the name of base object.

Group

published

Links
TADMetaInfoQuery Class, TADMetaInfoQuery Members, uADCompClient Namespace, Example 1, Example 2, published, See Also
Description

The BaseObjectName property value meaning and optionality depends on MetaInfoKind:

MetaInfoKind 
Meaning 
mkIndexFields 
Table name. 
mkPrimaryKeyFields 
Table name. 
mkForeignKeyFields 
Table name. 
mkProcs 
Package name. 
mkProcArgs 
Package name. 

The BaseObjectName property value together with CatalogName and SchemaName constitutes the full base object name. If current DBMS session may "see" few objects with the same name, but in different catalogs and/or schemas, then we strongly suggest to specify CatalogName and/or SchemaName property values to explicitly limit the list of objects. 

If BaseObjectName is case sensitive or contains special character, then it must be explicitly quoted. 

Assignment to this property value closes dataset.

Syntax
property BaseObjectName: String;
See Also
Example 1
  // SQL Server: retrieve foreign key fields for FK_DEPARTMENTS constraint of the Northwind.dbo.Employees table
  ADMetaInfoQuery1.BaseObjectName := 'Northwind.dbo.Employees';
  ADMetaInfoQuery1.ObjectName := 'FK_DEPARTMENTS';
  ADMetaInfoQuery1.MetaInfoKind := mkForeignKeyFields;
  ADMetaInfoQuery1.Open;
Example 2
  // Oracle: retrieve procedure list for the SYS.DBMS_SQL package
  ADMetaInfoQuery1.BaseObjectName := 'SYS.DBMS_SQL';
  ADMetaInfoQuery1.MetaInfoKind := mkProcs;
  ADMetaInfoQuery1.Open;
What do you think about this topic? Send feedback!