TDAJoinSourceTableCollection
Overview
The TDAJoinSourceTableCollection class represents the collection of source tables (TDAJoinSourceTable objects) in specified JOIN statements.
The TDAJoinSourceTableCollection collection is used to create JOIN statements by the Query Builder in automatic mode.
You can use the TDAJoinSourceTableCollection collection in the specified TDASchema component as part of the JoinDataTables property to define the collection of source tables that will take part in the creating of JOIN statements in autogenerated SQL statements.
Location
- Unit: uDACore.pas
- Ancestry: TOwnedCollection | TSearcheableCollection | TDAJoinSourceTableCollection
constructor Create (TPersistent)
Creates a new instance.
constructor Create(aOwner: TPersistent)
Parameters:
- aOwner: Specified owner of the current collection.
constructor Create (TPersistent, TCollectionItemClass) (declared in TSearcheableCollection)
Initializes the collection with the supplied parameters.
constructor Create(AOwner: TPersistent; ItemClass: TCollectionItemClass)
Parameters:
- AOwner: owner
- ItemClass: item class
Add reintroduce
Adds a new JOIN source table item (TDAJoinSourceTable object) to the current collection and returns the created item.
function Add: TDAJoinSourceTable
CloneItem (declared in TSearcheableCollection)
Inserts a copy of an item and names it "Copy nn of " of the cloned item name.
function CloneItem(iIndex: Integer): Integer
Parameters:
- iIndex: position.
FindItem virtual (declared in TSearcheableCollection)
Finds the first occurrence of the item with the supplied name. Search is case-insensitive.
function FindItem(const aName: string): TCollectionItem
Parameters:
- aName: the supplied name
FindUniqueName (declared in TSearcheableCollection)
Returns the supplied name if the item with that name is absent in the collection or adds a number to it and sequentially increments it until the result is unique.
function FindUniqueName(const iBaseName: string): string
Parameters:
- iBaseName: the supplied name
FindUniqueNameEx (declared in TSearcheableCollection)
Does the same as FindUniqueName, but uses a template with a numeric parameter as second argument, it should be compatible with the Delphi Format function.
function FindUniqueNameEx(const iBaseName: string; const iNumberedName: string): string
Parameters:
- iBaseName: the supplied name
- iNumberedName: numeric parameter
GetDefaultItem (declared in TSearcheableCollection)
Looks for the first occurrence of the item that has a boolean property with the name "Default" and the value true. Raises an exception if no such item can be found.
function GetDefaultItem: TCollectionItem
GetItemDefault protected dynamic (declared in TSearcheableCollection)
Returns default item's name
function GetItemDefault(anItem: TCollectionItem): Boolean
Parameters:
- anItem: given item
GetItemName protected override
Gets the name of the specified item.
function GetItemName(anItem: TCollectionItem): string
Parameters:
- anItem: the specified item.
ItemByName (declared in TSearcheableCollection)
Returns an item with the specified name.
function ItemByName(const aName: string): TCollectionItem
Parameters:
- aName: fClientFields
ItemName protected virtual (declared in TSearcheableCollection)
Returns the string "item".
function ItemName: string
JoinSourceTableByName
Gets the item (TDAJoinSourceTable object) with the specified name from the current collection and returns it. If no item with that name is found, an exception will be raised.
function JoinSourceTableByName(const aName: string): TDAJoinSourceTable
Parameters:
- aName: Specified name of the item in the current collection.
JoinSourceTables
Represents the single source table (TDAJoinSourceTable object) with the specified index in the current collection.
property JoinSourceTables[Index: Integer]: TDAJoinSourceTable read write
MoveItem (declared in TSearcheableCollection)
Moves the item from one position to another. Checks boundaries.
procedure MoveItem(iFromIndex: Integer; iToIndex: Integer)
Parameters:
- iFromIndex: old index
- iToIndex: new index
Notify protected override (declared in TSearcheableCollection)
Notifies about the adding or removal of an item if the event handler is assigned. If an item with an empty name is added and items without name are not allowed, it sets the name to "Item" plus number.
procedure Notify(Item: TCollectionItem; Action: TCollectionNotification)
Parameters:
- Item: given item
- Action: action
OnItemRemoved (declared in TSearcheableCollection)
Event handler for removing an item.
property OnItemRemoved: TDAItemRemovedEvent read write
delegate: procedure OnItemRemoved(aSender: TObject; const aName: string)
OnItemRenamed (declared in TSearcheableCollection)
Event handler for renaming an item.
property OnItemRenamed: TDAItemRenamedEvent read write
delegate: procedure OnItemRenamed(aSender: TObject; const aOldName: string; const aNewName: string)
SetItemName protected override
Sets a new name for the specified item.
function SetItemName(anItem: TCollectionItem; const aName: string): string
Parameters:
- anItem: item
- aName: name
TriggerOnItemRemoved virtual (declared in TSearcheableCollection)
Calls the event handler if it was assigned.
procedure TriggerOnItemRemoved(const iName: string)
Parameters:
- iName: item name
TriggerOnItemRenamed virtual (declared in TSearcheableCollection)
Calls the event handler if it was assigned.
procedure TriggerOnItemRenamed(const iOldName: string; const iNewName: string)
Parameters:
- iOldName: old name
- iNewName: new name
JoinSourceTables
Represents the single source table (TDAJoinSourceTable object) with the specified index in the current collection.
property JoinSourceTables[Index: Integer]: TDAJoinSourceTable read write
constructor Create (TPersistent)
Creates a new instance.
constructor Create(aOwner: TPersistent)
Parameters:
- aOwner: Specified owner of the current collection.
constructor Create (TPersistent, TCollectionItemClass) (declared in TSearcheableCollection)
Initializes the collection with the supplied parameters.
constructor Create(AOwner: TPersistent; ItemClass: TCollectionItemClass)
Parameters:
- AOwner: owner
- ItemClass: item class
Add reintroduce
Adds a new JOIN source table item (TDAJoinSourceTable object) to the current collection and returns the created item.
function Add: TDAJoinSourceTable
CloneItem (declared in TSearcheableCollection)
Inserts a copy of an item and names it "Copy nn of " of the cloned item name.
function CloneItem(iIndex: Integer): Integer
Parameters:
- iIndex: position.
FindItem virtual (declared in TSearcheableCollection)
Finds the first occurrence of the item with the supplied name. Search is case-insensitive.
function FindItem(const aName: string): TCollectionItem
Parameters:
- aName: the supplied name
FindUniqueName (declared in TSearcheableCollection)
Returns the supplied name if the item with that name is absent in the collection or adds a number to it and sequentially increments it until the result is unique.
function FindUniqueName(const iBaseName: string): string
Parameters:
- iBaseName: the supplied name
FindUniqueNameEx (declared in TSearcheableCollection)
Does the same as FindUniqueName, but uses a template with a numeric parameter as second argument, it should be compatible with the Delphi Format function.
function FindUniqueNameEx(const iBaseName: string; const iNumberedName: string): string
Parameters:
- iBaseName: the supplied name
- iNumberedName: numeric parameter
GetDefaultItem (declared in TSearcheableCollection)
Looks for the first occurrence of the item that has a boolean property with the name "Default" and the value true. Raises an exception if no such item can be found.
function GetDefaultItem: TCollectionItem
GetItemDefault protected dynamic (declared in TSearcheableCollection)
Returns default item's name
function GetItemDefault(anItem: TCollectionItem): Boolean
Parameters:
- anItem: given item
GetItemName protected override
Gets the name of the specified item.
function GetItemName(anItem: TCollectionItem): string
Parameters:
- anItem: the specified item.
ItemByName (declared in TSearcheableCollection)
Returns an item with the specified name.
function ItemByName(const aName: string): TCollectionItem
Parameters:
- aName: fClientFields
ItemName protected virtual (declared in TSearcheableCollection)
Returns the string "item".
function ItemName: string
JoinSourceTableByName
Gets the item (TDAJoinSourceTable object) with the specified name from the current collection and returns it. If no item with that name is found, an exception will be raised.
function JoinSourceTableByName(const aName: string): TDAJoinSourceTable
Parameters:
- aName: Specified name of the item in the current collection.
MoveItem (declared in TSearcheableCollection)
Moves the item from one position to another. Checks boundaries.
procedure MoveItem(iFromIndex: Integer; iToIndex: Integer)
Parameters:
- iFromIndex: old index
- iToIndex: new index
Notify protected override (declared in TSearcheableCollection)
Notifies about the adding or removal of an item if the event handler is assigned. If an item with an empty name is added and items without name are not allowed, it sets the name to "Item" plus number.
procedure Notify(Item: TCollectionItem; Action: TCollectionNotification)
Parameters:
- Item: given item
- Action: action
SetItemName protected override
Sets a new name for the specified item.
function SetItemName(anItem: TCollectionItem; const aName: string): string
Parameters:
- anItem: item
- aName: name
TriggerOnItemRemoved virtual (declared in TSearcheableCollection)
Calls the event handler if it was assigned.
procedure TriggerOnItemRemoved(const iName: string)
Parameters:
- iName: item name
TriggerOnItemRenamed virtual (declared in TSearcheableCollection)
Calls the event handler if it was assigned.
procedure TriggerOnItemRenamed(const iOldName: string; const iNewName: string)
Parameters:
- iOldName: old name
- iNewName: new name
OnItemRemoved (declared in TSearcheableCollection)
Event handler for removing an item.
property OnItemRemoved: TDAItemRemovedEvent read write
delegate: procedure OnItemRemoved(aSender: TObject; const aName: string)
OnItemRenamed (declared in TSearcheableCollection)
Event handler for renaming an item.
property OnItemRenamed: TDAItemRenamedEvent read write
delegate: procedure OnItemRenamed(aSender: TObject; const aOldName: string; const aNewName: string)