Consultingwerk.OERA.BusinessEntityResultsetMapper

Namespace:

Consultingwerk.OERA

Class

BusinessEntityResultsetMapper

Parent classes:

Progress.Lang.Object

Consultingwerk.OERA.BusinessEntityResultsetMapper

Inherits:

Progress.Lang.Object

File:	BusinessEntityResultsetMapper
Purpose:	Allows mapping a Business Entity Resultset (ProDataset)
	into a Temp-Table
Author(s):	Mike Fechner / Consultingwerk Ltd.
Created:	Fri Dec 12 14:22:42 CET 2014
Notes:	SCL-587

Top Method Summary

Options	Name	Purpose
+	MapResultsetIntoTempTable (handle, character, character, character, table-handle)	Appends records from the passed ProDataset to the provided temp-table. Supports joining multiple ProDataset records (parent/child) and field mapping.
+	MapResultsetIntoTempTable (handle, character, character, character, character, table-handle)	Appends records from the passed ProDataset to the provided temp-table. Supports joining multiple ProDataset records (parent/child) and field mapping.
+	MapResultsetIntoTempTable (handle, character, character, character, character[], table-handle)	Appends records from the passed ProDataset to the provided temp-table. Supports joining multiple ProDataset records (parent/child) and field mapping.
+	MapResultsetIntoTempTable (handle, handle, character, character)	Merges ProDataset records from the passed ProDataset to the provided target temp-table record Supports joining multiple ProDataset records (parent/child) and field mapping.
+	MapResultsetIntoTempTable (handle, handle, character, character[])	Merges ProDataset records from the passed ProDataset to the provided target temp-table record Supports joining multiple ProDataset records (parent/child) and field mapping.
+	RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, table-handle)	Fetches Records from a Business Entity and appends them based on the provided field mapping to the provided temp-table
+	RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, character, table-handle)	Fetches Records from a Business Entity and appends them based on the provided field mapping to the provided temp-table
+	RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, character[], table-handle)	Fetches Records from a Business Entity and appends them based on the provided field mapping to the provided temp-table

Top Property Summary

	Options	Name	Purpose
	+	CHARACTER AppServerPartition

Method Detail

Top

PUBLIC MapResultsetIntoTempTable (handle, character, character, character, table-handle)

Purpose:	Appends records from the passed ProDataset to the provided temp-table.
	Supports joining multiple ProDataset records (parent/child) and field
	mapping.
Notes:	The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
	calls to this method with the same temp-table. This may be useful
	when multiple backend calls (queries to the same or different Business
	Entity) should be added to the same view temp-table in a sequence. Like
	when populating the AKIOMA SWAT tree of struct records.

Parameters:
phDataset	HANDLE
	The handle of the ProDataset with the data to map to the temp-table
pcEntityTable	CHARACTER
	The Entity Table
pcEntityView	CHARACTER
	The comma delimited list of additional business entity tables
pcEntityTableMappings	CHARACTER
	The fields to map for the entity table
phTable	TABLE-HANDLE
	INPUT-OUTPUT BY-REFERENCE The result temp-table

Top

PUBLIC MapResultsetIntoTempTable (handle, character, character, character, character, table-handle)

Purpose:	Appends records from the passed ProDataset to the provided temp-table.
	Supports joining multiple ProDataset records (parent/child) and field
	mapping.
Notes:	The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
	calls to this method with the same temp-table. This may be useful
	when multiple backend calls (queries to the same or different Business
	Entity) should be added to the same view temp-table in a sequence. Like
	when populating the AKIOMA SWAT tree of struct records.

Parameters:
phDataset	HANDLE
	The handle of the ProDataset with the data to map to the temp-table
pcEntityTable	CHARACTER
	The Entity Table
pcEntityView	CHARACTER
	The comma delimited list of additional business entity tables
pcEntityTableMappings	CHARACTER
	The fields to map for the entity table
pcEntityViewMappings	CHARACTER
	The comma delimited list of fields to map for the entity view table (only one)
phTable	TABLE-HANDLE
	INPUT-OUTPUT BY-REFERENCE The result temp-table

Top

PUBLIC MapResultsetIntoTempTable (handle, character, character, character, character[], table-handle)

Purpose:	Appends records from the passed ProDataset to the provided temp-table.
	Supports joining multiple ProDataset records (parent/child) and field
	mapping.
Notes:	The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
	calls to this method with the same temp-table. This may be useful
	when multiple backend calls (queries to the same or different Business
	Entity) should be added to the same view temp-table in a sequence. Like
	when populating the AKIOMA SWAT tree of struct records.

Parameters:
phDataset	HANDLE
	The handle of the ProDataset with the data to map to the temp-table
pcEntityTable	CHARACTER
	The Entity Table
pcEntityView	CHARACTER
	The comma delimited list of additional business entity tables
pcEntityTableMappings	CHARACTER
	The fields to map for the entity table
pcEntityViewMappings	CHARACTER
	The Character array of fields to map for the entity view tables, extent of the array needs to match the number of view tables
phTable	TABLE-HANDLE
	INPUT-OUTPUT BY-REFERENCE The result temp-table

Top

PUBLIC MapResultsetIntoTempTable (handle, handle, character, character)

Purpose:	Merges ProDataset records from the passed ProDataset to the provided
	target temp-table record
	Supports joining multiple ProDataset records (parent/child) and field
	mapping.
Notes:	The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
	calls to this method with the same temp-table. This may be useful
	when multiple backend calls (queries to the same or different Business
	Entity) should be added to the same view temp-table in a sequence. Like
	when populating the AKIOMA SWAT tree of struct records.

Parameters:
phTempTableBuffer	HANDLE
	The buffer of a temp-table to copy the record to
phQueryHandle	HANDLE
	The handle of the query that joins the EntityTable with the EntityView Tables. This query needs to be repositioned (by your code) to the proper result row
pcEntityTableMappings	CHARACTER
	The fields to map for the entity table
pcEntityViewMappings	CHARACTER
	The comma delimited list of fields to map for the entity view tables, extent of the array needs to match the number of view tables

Top

PUBLIC MapResultsetIntoTempTable (handle, handle, character, character[])

Purpose:	Merges ProDataset records from the passed ProDataset to the provided
	target temp-table record
	Supports joining multiple ProDataset records (parent/child) and field
	mapping.
Notes:	The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
	calls to this method with the same temp-table. This may be useful
	when multiple backend calls (queries to the same or different Business
	Entity) should be added to the same view temp-table in a sequence. Like
	when populating the AKIOMA SWAT tree of struct records.

Parameters:
phTempTableBuffer	HANDLE
	The buffer of a temp-table to copy the record to
phQueryHandle	HANDLE
	The handle of the query that joins the EntityTable with the EntityView Tables. This query needs to be repositioned (by the callers code) to the proper result row
pcEntityTableMappings	CHARACTER
	The fields to map for the entity table
pcEntityViewMappings	CHARACTER
	The Character array of fields to map for the entity view tables, extent of the array needs to match the number of view tables

Top

PUBLIC RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, table-handle)

Purpose:	Fetches Records from a Business Entity and appends them based on
	the provided field mapping to the provided temp-table
Notes:	The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
	calls to this method with the same temp-table. This may be useful
	when multiple backend calls (queries to the same or different Business
	Entity) should be added to the same view temp-table in a sequence. Like
	when populating the AKIOMA SWAT tree of struct records.

Parameters:
pcBusinessEntity	CHARACTER
	The Business Entity Name to retrieve records from
pcEntityTable	CHARACTER
	The Entity Table
pcEntityView	CHARACTER
	The comma delimited list of additional business entity tables
poQueryExpression	Consultingwerk.IQueryExpression
	The QueryExpression to use for the filter
pcEntityTableMappings	CHARACTER
	The fields to map for the entity table
phTable	TABLE-HANDLE
	INPUT-OUTPUT BY-REFERENCE The result temp-table

Top

PUBLIC RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, character, table-handle)

Purpose:	Fetches Records from a Business Entity and appends them based on
	the provided field mapping to the provided temp-table
Notes:	The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
	calls to this method with the same temp-table. This may be useful
	when multiple backend calls (queries to the same or different Business
	Entity) should be added to the same view temp-table in a sequence. Like
	when populating the AKIOMA SWAT tree of struct records.

Parameters:
pcBusinessEntity	CHARACTER
	The Business Entity Name to retrieve records from
pcEntityTable	CHARACTER
	The Entity Table
pcEntityView	CHARACTER
	The comma delimited list of additional business entity tables
poQueryExpression	Consultingwerk.IQueryExpression
	The QueryExpression to use for the filter
pcEntityTableMappings	CHARACTER
	The fields to map for the entity table
pcEntityViewMappings	CHARACTER
	The comma delimited list fields to map for the entity view table (only the first one)
phTable	TABLE-HANDLE
	INPUT-OUTPUT BY-REFERENCE The result temp-table

Top

PUBLIC RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, character[], table-handle)

Purpose:	Fetches Records from a Business Entity and appends them based on
	the provided field mapping to the provided temp-table
Notes:	The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
	calls to this method with the same temp-table. This may be useful
	when multiple backend calls (queries to the same or different Business
	Entity) should be added to the same view temp-table in a sequence. Like
	when populating the AKIOMA SWAT tree of struct records.

Parameters:
pcBusinessEntity	CHARACTER
	The Business Entity Name to retrieve records from
pcEntityTable	CHARACTER
	The Entity Table
pcEntityView	CHARACTER
	The comma delimited list of additional business entity tables
poQueryExpression	Consultingwerk.IQueryExpression
	The QueryExpression to use for the filter
pcEntityTableMappings	CHARACTER
	The fields to map for the entity table
pcEntityViewMappings	CHARACTER
	The Character array of fields to map for the entity view tables, extent of the array needs to match the number of view tables
phTable	TABLE-HANDLE
	INPUT-OUTPUT BY-REFERENCE The result temp-table

Property Detail

Top

PUBLIC CHARACTER AppServerPartition

Returns	CHARACTER

info@consultingwerk.de http://www.consultingwerk.de 04.02.2020 23:14:14