Namespace: Consultingwerk.SmartFramework
Interface 
IRelationService Copy to Clipboard
Parent classes:
Inherits: Progress.Lang.Object
Implemented by: Consultingwerk.SmartFramework.System.SmartRelationService

Purpose: Returns the handle of a query (prepared, opened and located at the
first record) of all child records of the given child record
Notes:

Navigate to: Methods | Constructors | Events | Properties | ProDatasets | Temp-Tables



Top Method Summary
Options Name Purpose
+ HANDLE GetChildRecordQueryOf (handle, handle) Returns the handle of a query (prepared, opened and located at the first record) of all child records of the given child record
+ HANDLE GetChildRecordQueryOf (handle, handle, IRelationServiceQueryCustomizer) Returns the handle of a query (prepared, opened and located at the first record) of all child records of the given child record
+ HANDLE GetFirstChildRecordOf (handle, character) Returns the first child record of the given child record
+ CHARACTER GetParentDescriptionForField (handle, character) Returns the description value for the parent record referenced by the given field.
+ CHARACTER GetParentDescriptionForFieldValue (character, character) Returns the description value for the parent record referenced by the given field.
+ CHARACTER GetParentDescriptionOf (handle) Returns the description value for the default parent record of the given child buffer
+ HANDLE GetParentRecordForField (handle, character) Returns the first parent record referenced by the given child field
+ HANDLE GetParentRecordOf (handle) Returns the first parent record of the given child record
+ HANDLE GetParentRecordQueryForField (handle, character, handle) Returns the handle of a query (prepared, opened and located at the first record) of all parent records of the given child record
+ HANDLE GetParentRecordQueryOf (handle, handle) Returns the handle of a query (prepared, opened and located at the first record) of all parent records of the given child record
+ HANDLE GetParentRecordQueryOf (handle, handle, IRelationServiceQueryCustomizer) Returns the handle of a query (prepared, opened and located at the first record) of all parent records of the given child record
+ CHARACTER GetParentRoleForChildField (character) Returns the name of the parent role for the given child field
+ ProcessDelete (handle, logical, IRelationServiceQueryCustomizer) Processes the delete of a parent buffer
+ ProcessDelete (handle, logical, IRelationServiceQueryCustomizer, logical) Processes the delete of a parent buffer
+ ProcessWrite (handle, logical, IRelationServiceQueryCustomizer) Processes the write of a child buffer
+ ProcessWrite (handle, logical, IRelationServiceQueryCustomizer, logical) Processes the write of a child buffer
+ RefreshCache () Refreshes the Cache used by the service
+ ValidateRelationFields (character, character, character) Validates the relation fields


Method Detail
Top

PUBLIC HANDLE GetChildRecordQueryOf (handle, handle)
Purpose: Returns the handle of a query (prepared, opened and located at the
first record) of all child records of the given child record
Notes:

Parameters:
phParentBuffer HANDLE
The handle of the database buffer with the parent record
phChildBuffer HANDLE
The handle of the CHild buffer which will be used in the returned query
Returns HANDLE
The handle of a database query of the child records
Top

PUBLIC HANDLE GetChildRecordQueryOf (handle, handle, IRelationServiceQueryCustomizer)
Purpose: Returns the handle of a query (prepared, opened and located at the
first record) of all child records of the given child record
Notes:

Parameters:
phParentBuffer HANDLE
The handle of the database buffer with the parent record
phChildBuffer HANDLE
The handle of the CHild buffer which will be used in the returned query
poQueryCustomizer Consultingwerk.Framework.IRelationServiceQueryCustomizer
The optional reference to the IRelationServiceQueryCustomizer instance
Returns HANDLE
The handle of a database query of the child records
Top

PUBLIC HANDLE GetFirstChildRecordOf (handle, character)
Purpose: Returns the first child record of the given child record
Notes:

Parameters:
phParentBuffer HANDLE
The handle of the database buffer with the parent record
pcChildTableName CHARACTER
The name of the database table with the child record
Returns HANDLE
The handle of a database buffer with the child record
Top

PUBLIC CHARACTER GetParentDescriptionForField (handle, character)
Purpose: Returns the description value for the parent record referenced by
the given field.
Notes: The parent relation is identified by the child buffer name and the
relation based on the given child field name

Parameters:
phChildBuffer HANDLE
The handle of the database buffer with the child record
pcChildFieldName CHARACTER
The unqualified field name of the child buffer that references the parent table
Returns CHARACTER
The description value of the parent record as returned by the ITableInfoProvider.RecordDescription() method
Top

PUBLIC CHARACTER GetParentDescriptionForFieldValue (character, character)
Purpose: Returns the description value for the parent record referenced by
the given field.
Notes: The parent relation is identified by the child buffer name and the
relation based on the given child field name

Parameters:
pcChildFieldName CHARACTER
The qualified field name of the child buffer that references the parent table
pcValue CHARACTER
The value to return
Returns CHARACTER
The description value of the parent record as returned by the ITableInfoProvider.RecordDescription() method
Top

PUBLIC CHARACTER GetParentDescriptionOf (handle)
Purpose: Returns the description value for the default parent record of the
given child buffer
Notes:

Parameters:
phChildBuffer HANDLE
The handle of the database buffer with the child record
Returns CHARACTER
The description value of the parent record as returned by the ITableInfoProvider.RecordDescription() method
Top

PUBLIC HANDLE GetParentRecordForField (handle, character)
Purpose: Returns the first parent record referenced by the given child field
Notes: The parent relation is identified by the child buffer name and the
relation based on the given child field name

Parameters:
phChildBuffer HANDLE
The handle of the database buffer with the child record
pcChildFieldName CHARACTER
The unqualified field name of the child buffer that references the parent table
Returns HANDLE
The handle of a database buffer with the parent record
Top

PUBLIC HANDLE GetParentRecordOf (handle)
Purpose: Returns the first parent record of the given child record
Notes:

Parameters:
phChildBuffer HANDLE
The handle of the database buffer with the child record
Returns HANDLE
The handle of a database buffer with the parent record
Top

PUBLIC HANDLE GetParentRecordQueryForField (handle, character, handle)
Purpose: Returns the handle of a query (prepared, opened and located at the
first record) of all parent records of the given child record
Notes:

Parameters:
phChildBuffer HANDLE
The handle of the database buffer with the child record
pcChildFieldName CHARACTER
The unqualified field name of the child buffer that references the parent table
phParentBuffer HANDLE
The handle of the database buffer for the parent record, this buffer will be navigated by the returned query
Returns HANDLE
The handle of a database query of the parent records
Top

PUBLIC HANDLE GetParentRecordQueryOf (handle, handle)
Purpose: Returns the handle of a query (prepared, opened and located at the
first record) of all parent records of the given child record
Notes:

Parameters:
phChildBuffer HANDLE
The handle of the database buffer with the child record
phParentBuffer HANDLE
The handle of the database buffer for the parent record, this buffer will be navigated by the returned query
Returns HANDLE
The handle of a database query of the parent records
Top

PUBLIC HANDLE GetParentRecordQueryOf (handle, handle, IRelationServiceQueryCustomizer)
Purpose: Returns the handle of a query (prepared, opened and located at the
first record) of all parent records of the given child record
Notes:

Parameters:
phChildBuffer HANDLE
The handle of the database buffer with the child record
phParentBuffer HANDLE
The handle of the database buffer for the parent record, this buffer will be navigated by the returned query
poQueryCustomizer Consultingwerk.Framework.IRelationServiceQueryCustomizer
The optional reference to the IRelationServiceQueryCustomizer instance
Returns HANDLE
The handle of a database query of the parent records
Top

PUBLIC CHARACTER GetParentRoleForChildField (character)
Purpose: Returns the name of the parent role for the given child field
Notes:

Parameters:
pcChildFieldName CHARACTER
The qualified field name of the child buffer that references the parent table
Returns CHARACTER
The name of the parent field
Top

PUBLIC ProcessDelete (handle, logical, IRelationServiceQueryCustomizer)
Purpose: Processes the delete of a parent buffer
Notes: On delete restrict, on delete cascade
Optionally deletes the parent buffer as well

Parameters:
phBuffer HANDLE
The handle of the database buffer (parent) to process delete for
plDeleteParent LOGICAL
Logical parameter, indicating of the parent buffer should actually be deleted
poQueryCustomizer Consultingwerk.Framework.IRelationServiceQueryCustomizer
The optional reference to the IRelationServiceQueryCustomizer instance
Top

PUBLIC ProcessDelete (handle, logical, IRelationServiceQueryCustomizer, logical)
Purpose: Processes the delete of a parent buffer
Notes: On delete restrict, on delete cascade
Optionally deletes the parent buffer as well

Parameters:
phBuffer HANDLE
The handle of the database buffer (parent) to process delete for
plDeleteParent LOGICAL
Logical parameter, indicating of the parent buffer should actually be deleted
poQueryCustomizer Consultingwerk.Framework.IRelationServiceQueryCustomizer
The optional reference to the IRelationServiceQueryCustomizer instance
plUseNoWaitForReferentialIntegrity LOGICAL
Use NO-WAIT for exclusive-lock record access
Top

PUBLIC ProcessWrite (handle, logical, IRelationServiceQueryCustomizer)
Purpose: Processes the write of a child buffer
Notes:

Parameters:
phBuffer HANDLE
The handle of the database buffer (parent) to process the write for
plNewRecord LOGICAL
Logical parameter, indicating if the record has been created or updated
poQueryCustomizer Consultingwerk.Framework.IRelationServiceQueryCustomizer
The optional reference to the IRelationServiceQueryCustomizer instance
Top

PUBLIC ProcessWrite (handle, logical, IRelationServiceQueryCustomizer, logical)
Purpose: Processes the write of a child buffer
Notes:

Parameters:
phBuffer HANDLE
The handle of the database buffer (parent) to process the write for
plNewRecord LOGICAL
Logical parameter, indicating if the record has been created or updated
poQueryCustomizer Consultingwerk.Framework.IRelationServiceQueryCustomizer
The optional reference to the IRelationServiceQueryCustomizer instance
plUseNoWaitForReferentialIntegrity LOGICAL
Use NO-WAIT for exclusive-lock record access
Top

PUBLIC RefreshCache ()
Purpose: Refreshes the Cache used by the service
Notes: When no cache is used by the service, this method should not throw an error

Top

PUBLIC ValidateRelationFields (character, character, character)
Purpose: Validates the relation fields
Notes:

Parameters:
pcParentTableName CHARACTER
The name of the parent table
pcChildTableName CHARACTER
The name of the child table
pcRelationFieldPairs CHARACTER
The pairs of relation fields


©2006-2023 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       08.12.2024 13:06:52