DerivedTables (Collection)

Member of:

Represents derived tables in a DMCatalog object

Tip:

All collections have a method named “Item(NameOrIndex).” This is the default method for all collections and returns an item in the collection at a particular index or with a specific name. Use brackets ([]) to represent calls to the Item (Method). For example, these statements are identical: myItem = Documents[1] myItem = Documents.Item(1) myItem = Documents["StartUp.bqy"] myItem = Documents.Item("StartUp.bqy")

Example:

This example shows how to count derivable queries in the Table Catalog and display the number in an Alert box:

Alert(ActiveDocument.Sections["Query"].DataModel.Catalog.DerivableQueries.Count)

Methods:

Add(DerivableQuery DerivableQueryObject), Item(Value NameOrIndex), RemoveAll()

Properties:

Read-only: Property Count As Number