Namespace: Consultingwerk.OERA.Ccs
Class 
QueryBuilder Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.OERA.Ccs.QueryBuilder

Inherits: Progress.Lang.Object


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



Top Method Summary
Options Name Purpose
LOGICAL AllEntriesAnd (IQueryGroup) Determines if all entries are joined by AND or AND NOT
CHARACTER BuildQueryString (character, IQueryDefinition) Returns the ABL Query String for the abstract query
CHARACTER BuildQueryString (character, IQueryDefinition, logical) Returns the ABL Query String for the abstract query
CHARACTER FromQueryGroup (character, IQueryGroup, logical, character, logical) Extends the query string with the given query group
CHARACTER FromQueryPredicate (character, IQueryPredicate, character, logical) Adds a single query predicate to a query string
CHARACTER InListQueryString (IQueryPredicate, character, logical) Returns the QueryString for an InList QuerY Predicate
CHARACTER OperatorFromJoin (JoinEnum, character) Returns the query representation for the JoinEnum value
Ccs.BusinessLogic.IQueryEntry OptimizeQuerySelection (IQueryEntry) Performs query optimization
CHARACTER QueryValue (IPrimitiveArrayHolder, integer) Returns the (quoted) query string value from an array holder
CHARACTER QueryValue (IPrimitiveHolder) Returns the (quoted) query string value
INTEGER QueryValueExtent (IPrimitiveArrayHolder) Returns the extent size of the value from an array holder


Method Detail
Top

LOGICAL AllEntriesAnd (IQueryGroup)
Purpose: Determines if all entries are joined by AND or AND NOT
Notes:

Parameters:
poQueryGroup Ccs.BusinessLogic.IQueryGroup
The QueryGroup to test
Returns LOGICAL
Logical value indicating if all entries are joined by And or AndNot
Top

CHARACTER BuildQueryString (character, IQueryDefinition)
Purpose: Returns the ABL Query String for the abstract query
Notes: Does currently not take joined data-sources into account (data-source using a query with 2 or more buffers)

Parameters:
pcTableName CHARACTER
The name of the table
poQueryDefinition Ccs.BusinessLogic.IQueryDefinition
The IQueryDefinition that describes the query
Returns CHARACTER
The ABL query string
Top

CHARACTER BuildQueryString (character, IQueryDefinition, logical)
Purpose: Returns the ABL Query String for the abstract query
Notes: Does currently not take joined data-sources into account (data-source using a query with 2 or more buffers)

Parameters:
pcTableName CHARACTER
The name of the table
poQueryDefinition Ccs.BusinessLogic.IQueryDefinition
The IQueryDefinition that describes the query
plQualifyFieldsWithTable LOGICAL
Logical value indicating if the fields should be qualified with the table name
Returns CHARACTER
The ABL query string
Top

CHARACTER FromQueryGroup (character, IQueryGroup, logical, character, logical)
Purpose: Extends the query string with the given query group
Notes:

Parameters:
pcQueryString CHARACTER
The original query string
poQueryGroup Ccs.BusinessLogic.IQueryGroup
The query group to add to the query string
plOutermost LOGICAL
Logical value indicating if the query string contains the outer most query selection
pcTableName CHARACTER
The name of the table
plQualifyFieldsWithTable LOGICAL
Logical value indicating if the fields should be qualified with the table name
Returns CHARACTER
The new query string
Top

CHARACTER FromQueryPredicate (character, IQueryPredicate, character, logical)
Purpose: Adds a single query predicate to a query string
Notes:

Parameters:
pcQueryString CHARACTER
The query string to add the predicate to
poQueryPredicate Ccs.BusinessLogic.IQueryPredicate
The query predicate to add to the string
pcTableName CHARACTER
The name of the table
plQualifyFieldsWithTable LOGICAL
Logical value indicating if the fields should be qualified with the table name
Returns CHARACTER
The resulting query string
Top

CHARACTER InListQueryString (IQueryPredicate, character, logical)
Purpose: Returns the QueryString for an InList QuerY Predicate
Notes:

Parameters:
poQueryPredicate Ccs.BusinessLogic.IQueryPredicate
The query predicate to add to the string
pcTableName CHARACTER
The name of the table
plQualifyFieldsWithTable LOGICAL
Logical value indicating if the fields should be qualified with the table name
Returns CHARACTER
The resulting query string
Top

CHARACTER OperatorFromJoin (JoinEnum, character)
Purpose: Returns the query representation for the JoinEnum value
Notes:

Parameters:
poJoin Ccs.BusinessLogic.JoinEnum
The JoinEnum value
pcQueryString CHARACTER
The query string to add the operator to (to determine if this is the first entry)
Returns CHARACTER
The character representation of the join operator
Top

Ccs.BusinessLogic.IQueryEntry OptimizeQuerySelection (IQueryEntry)
Purpose: Performs query optimization
Notes:

Parameters:
poQueryEntry Ccs.BusinessLogic.IQueryEntry
The Query Entry to optimize
Returns Ccs.BusinessLogic.IQueryEntry
The optimized query entry
Top

CHARACTER QueryValue (IPrimitiveArrayHolder, integer)
Purpose: Returns the (quoted) query string value from an array holder
Notes:

Parameters:
poPrimitiveHolder Ccs.Common.Support.IPrimitiveArrayHolder
The IPrimitiveHolder representing the value
piIndex INTEGER
The array index
Returns CHARACTER
The quoted CHARACTER string representing the value
Top

CHARACTER QueryValue (IPrimitiveHolder)
Purpose: Returns the (quoted) query string value
Notes:

Parameters:
poPrimitiveHolder Ccs.Common.Support.IPrimitiveHolder
The IPrimitiveHolder representing the value
Returns CHARACTER
The quoted CHARACTER string representing the value
Top

INTEGER QueryValueExtent (IPrimitiveArrayHolder)
Purpose: Returns the extent size of the value from an array holder
Notes:

Parameters:
poPrimitiveHolder Ccs.Common.Support.IPrimitiveArrayHolder
The IPrimitiveHolder representing the value
Returns INTEGER
The extent size


©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       01.06.2026 09:10:45