Namespace: Consultingwerk.OERA.Query
Class 
DSQueryStringForKeyValueTable Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.OERA.Query.QueryString
Consultingwerk.OERA.Query.DSQueryString
Consultingwerk.OERA.Query.DSQueryStringForKeyValueTable

Inherits: Consultingwerk.OERA.Query.DSQueryString
Implements: Consultingwerk.OERA.IDSQueryString, Consultingwerk.OERA.Query.IQueryMap, Consultingwerk.OERA.Query.IThrowsErrorsOnInvalidSourceMapping

File:DSQueryStringForKeyValueTable
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Sat Feb 07 15:27:26 CET 2015

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



Top Method Summary
Options Name Purpose
CHARACTER DefaultQuery () Returns the default query string for the data source
CHARACTER SourceColumn (character, character) Returns the database field name matching a temp-table field name contained in a consumers query string (query string vs. temp-table definition)

Top Constructor Summary
Options Name Purpose
DSQueryStringForKeyValueTable (character, DataAccess, character, logical, IFetchDataByKeyTableParameter, character) Constructor for the DSQueryStringForKeyValueTable class


Method Detail
Top

CHARACTER DefaultQuery ()
Purpose: Returns the default query string for the data source
Notes: Injects the join criteria from the key value table to the source tables

Returns CHARACTER
The default query string
Top

CHARACTER SourceColumn (character, character)
Purpose: Returns the database field name matching a temp-table field name
contained in a consumers query string (query string vs. temp-table
definition)
Notes: Call-back used by Consultingwerk.OERA.Query.DSQueryString (part of
DataAccess:FetchData FetchData () query preparation
TO-DO: Provide code for alternative mapping

Parameters:
pcFieldPairs CHARACTER
The field mapping of the data-source
pcColumn CHARACTER
The temp table column name to return the source (database table) field name for
Returns CHARACTER
The database field name mapped to the passed in temp-table field


Constructor Detail
Top

DSQueryStringForKeyValueTable (character, DataAccess, character, logical, IFetchDataByKeyTableParameter, character)
Purpose: Constructor for the DSQueryStringForKeyValueTable class
Notes:

Parameters:
pcQueryString CHARACTER
The query string from the current read request
phInstance Consultingwerk.OERA.DataAccess
The reference to the owning DataAccess class (for call backs)
pcTable CHARACTER
The name of the temp-table this DSQueryString instance is providing source query manipulation for
plFilterUsingInnerJoin LOGICAL
The value for the FilterUsingInnerJoin property
poFetchDataByKeyTableParameter Consultingwerk.OERA.IFetchDataByKeyTableParameter
The IFetchDataByKeyTableParameter with the data for the current poFetchDataByKeyTableParameter AS FetchDataByKeyTable call
pcFieldPairs CHARACTER
The DATA-SOURCE field mapping


©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       13.04.2026 10:22:32