Consultingwerk.OERA.DataAccess - SmartComponent Library

Namespace:

Consultingwerk.OERA

Class

DataAccess

Parent classes:

Progress.Lang.Object

Consultingwerk.OERA.DataAccess

Inherits:

Progress.Lang.Object

Implements:

Consultingwerk.OERA.IDataAccess, Consultingwerk.OERA.IDataAccessCanFind, Consultingwerk.OERA.IDataAccessCountRecords, Consultingwerk.OERA.Query.IDSQueryStringSource

Inherited by:

ABSTRACT

File:	DataAccess
Purpose:	Abstract base class for OERA Data Access objects
Author(s):	Mike Fechner / Consultingwerk Ltd.
Created:	Wed Feb 24 22:19:03 CET 2010
Notes:	SCL-1480: Now supports the SaveRowChanges custom log entry
	type to log details about "current row modified by another
	user" issues

Top Method Summary

Options	Name	Purpose
	ActivateDefaultRelations ()	Enables the given ProDataset relations. Disables all other parent-relations of the relation's child buffer */
	ActivateRelations (character)	Enables the given ProDataset relations. Disables all other parent-relations of the relation's child buffer
	AssignKeyFieldValues (handle)	Invoked by DataAccess:CommitChanges within the database transaction to optionally assign key field values for new records
	AssignKeyValue (handle, INameValuesPair, integer)	Assigns the value at index piIndex of a Name...ValuesPair instance to the corresponding field in the temp-table buffer
	LOGICAL AttachDataSource (handle, handle, character)	Attaches a data-source object to a temp-table buffer in a ProDataSet object
	LOGICAL AttachDataSource (handle, handle, character, character)	Attaches a data-source object to a temp-table buffer in a ProDataSet object
	LOGICAL AttachDataSource (handle, handle, character, character, character)	Attaches a data-source object to a temp-table buffer in a ProDataSet object
	LOGICAL AttachDataSource (handle, IBufferDataSource)	Attaches a data-source object generated by an BufferDataSource instance to a temp-table buffer in a ProDataSet object
	LOGICAL AttachDataSource (handle, IBufferDataSource, character)	Attaches a data-source object generated by an BufferDataSource instance to a temp-table buffer in a ProDataSet object
	LOGICAL AttachDataSource (handle, IBufferDataSource, character, character)	Attaches a data-source object generated by an BufferDataSource instance to a temp-table buffer in a ProDataSet object
	LOGICAL AttachDataSource (handle, IBufferDataSource, character, character, character)	Attaches a data-source object generated by an BufferDataSource instance to a temp-table buffer in a ProDataSet object
A	AttachDataSources ()	Attaches the DATA-SOURCE objects to the ProDataset Buffers
	CHARACTER BuildDataSourceQueryString (handle, IFetchDataRequest, character)	Returns the Query String to be used for the DATA-SOURCE of a ProDataset member buffer
	CHARACTER BuildDataSourceQueryString (handle, IFetchDataRequest, IQueryExpressionWithSort)	Returns the Query String to be used for the DATA-SOURCE of a ProDataset member buffer
	Consultingwerk.OERA.BufferDataSource BuildInnerJoinDataSource (integer, integer, character)	Builds and returns an initialized BufferDataSource carrying the source buffers needed by a single inner-join level fill (SCL-2351).
	CHARACTER BuildInnerJoinLevelQuery (integer, integer, character, character, character, character, character)	Builds the QUERY-PREPARE string for an inner-join level fill (SCL-2351).
	CanFind (CanFindParameter)	Returns a TRUE value if a record is found that meets the specified FIND criteria; otherwise it returns FALSE. CAN-FIND does not make the record available to the Business Entity or it's caller.
	CaptureInnerJoinLevelMetadata (handle, integer, character, character, character, character)	Captures per-level metadata required by the inner-join FetchData path (SCL-2351) before the static data-sources are detached.
	CheckForRecursiveRelationWithQuery ()	Checks if the ProDataset contains recursive relations and the top-level-buffer is using a query with the DATA-SOURCE
	CHARACTER CombineWhereAnd (character, character)	Returns the logical AND of two WHERE expressions, each parenthesized; either side may be empty.
	CommitChanges (handle)	This method is called from SaveChanges in the DA to do the actual database commit and any transaction-related validation logic for a buffer.
	INTEGER ComputeLevelVisitOrder (integer, integer, character)	Computes the level visit order for the inner-join data-source query of a single level fill (SCL-2351).
	INTEGER ComputeMaxFilteredLevel (IFetchDataRequest, integer)	Returns the deepest level index (1-based) that carries a non- empty user filter in the IFetchDataRequest:Queries CHR(1) delimited list.
	CountResultRecords (ICountRecordsRequest)	Counts the number of result records in the data source query
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character, character)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character, character, character)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character, character, character, character)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)	Creates a BufferDataSource
	Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)	Creates a BufferDataSource
	CustomizeFetchDataRequest (IFetchDataRequest)	Hook method to support customization the IFetchDataRequest or ICountRecordsRequest
	LOGICAL DatasetBufferFill (handle, IFetchDataRequest)	Invokes the FILL method of a ProDataset member buffer
	LOGICAL DatasetFill (handle, IFetchDataRequest)	Invokes the ProDataset FILL method
A	DefineReadEvents ()	TO-DO: Subscribe to ProDataset Event Handlers using SET-CALLBACK as needed
A	DetachDataSources ()	Detaches the DATA-SOURCE objects to the ProDataset Buffers
	EnableDataAccessQueryLogging ()	Enables DataAccessLogging
	CHARACTER ExpandTables (character)	Expands the FetchDataRequest:Tables parameter, in case it contains the * wild-card character
	FetchData (IFetchDataRequest)	Fetch data from the data source
	FetchDataByKeyTable (IFetchDataByKeyTableParameter)	Allows retrieve multiple DB records from a Business Entity based on a temp-table with key values
	FetchDataByKeyValues (FetchDataByKeysParameter)	Allows retrieve multiple DB records from a Business Entity based on extents of key values for one or more fields
	FetchDataByStaticQuery (IFetchDataByStaticQueryRequest)	Fetches data for single table, using a static query
	FetchDataByTempTable (table-handle, IFetchDataByTempTableParameter)	Supports retrieve multiple DB records from a Business Entity based on a join to an (external) temp-table
	FetchDataEmptyDataset (IFetchDataRequest)	Empties the Dataset before the request
	FetchDataFill (IFetchDataRequest, character, handle)	Invokes FILL on the Dataset or the given Dataset Buffer
	FetchDataFillFindRowWhereBatch (IFetchDataRequest, handle, integer, character[])	Verify that a FindRowWhere on the server does always return a full batch of records
	FetchDataFillRepositionTables (IFetchDataRequest, character)	FILL's buffers with REPOSITION parent-relations
	FetchDataHandleErrorStatus ()	Handles ERROR-STATUS after the FetchData's FILL
	FetchDataInnerJoins (IFetchDataRequest)	Implements the inner-join variant of FetchData (SCL-2351).
	FetchDataInnerJoinsCleanup ()	Releases the dynamic BufferDataSource instances built for the UseInnerJoins variant of FetchData.
	FetchDataInnerJoinsValidate (IFetchDataRequest)	Validates the applicability of the UseInnerJoins flag on the current request.
	FetchDataInternal (IFetchDataRequest, logical)	Fetch data from the data source
	FetchDataLogNextRowid (handle)	Logs the NEXT-ROWID and LAST-BATCH property of the fill-buffer
	FetchDataLogRestartRowid (handle)	Logs the RESTART-ROWID of the fill-buffer
	FetchDataPrepareChildTableQuery (IFetchDataRequest, handle, integer, character)	Prepares the query for a child table
	FetchDataPrepareParentTableQuery (IFetchDataRequest, handle, integer, integer, character, IQueryRowIdentifier, character, FindRecordResult, handle)	Prepares the query for a parent table
	FetchDataRestoreBatchSizes (integer[])	Restores the Batch-Size of the ProDataset buffers
	FetchDataSetBatchContext (handle, character)	Updates the batch context with the next-rowids
	FetchDataSetFillMode (IFetchDataRequest, handle)	Sets the FILL-MODE for a Temp-Table Buffer in preparation for a FILL() method call
	FetchDataUpdateRequestContext (IFetchDataRequest, integer, character, IQueryRowIdentifier, character, FindRecordResult)	Updates the NextContext, PrevContext and BatchContext properties of the IFetchDataInstance
	INTEGER FindFirstTopLevelComma (character, integer)	Returns the position of the first top-level comma in a query fragment, skipping commas inside parentheses or string literals.
	CHARACTER FindIndexByLeadingFields (handle, character)	Finds the first index of a buffer's table whose leading fields match the given comma-separated list of field names.
	ROWID FindRecord (character, handle, character, integer, integer)	Finds a record in the data source query and returns the ROWID ARRAY (used as RESTART-ROWID in FetchData)
	Consultingwerk.OERA.FindRecordResult FindRecord2 (character, handle, character, integer, integer)	Finds a record in the data source query and returns the ROWID ARRAY (used as RESTART-ROWID in FetchData)
	Consultingwerk.OERA.FindRecordResult FindRecord2 (character, handle, character, integer, integer, logical)	Finds a record in the data source query and returns the ROWID ARRAY (used as RESTART-ROWID in FetchData)
	Consultingwerk.OERA.FindRecordResult FindRecord2 (character, handle, IQueryExpressionWithSort, integer, integer, logical)	Finds a record in the data source query and returns the ROWID ARRAY (used as RESTART-ROWID in FetchData)
	FindSourceBuffer (handle, logical)	Locates the matching record in the first source buffer of the given Dataset Buffer
	CHARACTER ForeignKeyIndexForLevel (handle)	Returns the name of the database index on the level's primary source buffer whose leading fields match the parent-relation foreign-key fields.
	CHARACTER GetDefinedBufferName (character)	Finds a matching buffer name in the current dataset, and returns the defined buffer name
	CHARACTER GetDefinedBufferName (integer)	Finds a matching buffer name in the current dataset, and returns the defined buffer name
	CHARACTER GetKeyDataType (INameValuesPair)	Returns the ABL primitive data type for a Name...ValuesPair instance
	INTEGER GetKeyValuesExtent (INameValuesPair)	Returns the extent of the Values property of a Name...ValuesPair instance based on its concrete type
	HandleKnownCommitErrors (SysError, character, handle)	Handles known commit errors and adds error messages to the before buffer Notes : Extracted from CommitChanges (SysError catch block) @param poSysErr The SysError thrown by SAVE-ROW-CHANGES @param pcReturnValue The RETURN-VALUE after SAVE-ROW-CHANGES @param phBeforeBuff The handle of the before buffer */
	HandleRecordLockedError (handle, SysError)	Handles a record locked error invoked during the SAVE-ROW-CHANGES method
	InitializeDataAccessQueryLogging ()	Initializes DataAccessLogging
	CHARACTER InnerJoinSourceRelationExpression (handle)	Builds the inner-join WHERE expression that relates a child temp-table's source buffer(s) to its parent temp-table's source buffer(s), based on the dataset's data-relation foreign-fields.
	HANDLE InsertToDataSourceQuery (handle, IFetchDataRequest, character)	Creates a new Query to be used as a DATA-SOURCE for a ProDataset member buffer
	HANDLE InsertToDataSourceQuery (handle, IFetchDataRequest, IQueryExpressionWithSort)	Creates a new Query to be used as a DATA-SOURCE for a ProDataset member buffer
	InvokeCommitChangesCallback (CommitCallbackTypeEnum, handle)	Invokes a CommitChangesCallback
	LOGICAL IsQueryFlagPresent (character, character)	Returns if the passed in field (prefixed with the temp-table) is referenced in a list of query flag fields and is contained in the FetchDataRequest's QueryExpression
	LogCurrentRowModifiedIssue (handle)	Logs details about "current row has been modified by another user to the current logfile
	LogInnerJoinEffectiveQuery (integer, character, character, character)	Writes a log line that shows the effective inner-join query for a level - the QUERY-PREPARE string with the parent-temp- table relation join spliced into the first WHERE clause.
	LogUnableToFindDbBufferIssue (handle, Error)	Logs details about "Unable to find record for db buffer "name" during SAVE-ROW-CHANGES" to the current logfile
	Consultingwerk.OERA.IDSQueryString NewDSQueryString (character, character)	Factory method for the DSQueryString objects
	Consultingwerk.OERA.IDSQueryString NewDSQueryString (character, character, logical)	Factory method for the DSQueryString objects
	Consultingwerk.OERA.IDSQueryString NewDSQueryString (IQueryExpressionWithSort, character, logical)	Factory method for the DSQueryString objects
	Consultingwerk.OERA.IDSQueryString NewDSQueryStringForKeyValueTable (character, character, logical, IFetchDataByKeyTableParameter, character)	Factory method for the DSQueryStringForKeyValueTable objects
	Consultingwerk.OERA.IDSQueryString NewDSQueryStringForTempTable (character, character, logical, IFetchDataByTempTableParameter)	Factory method for the DSQueryStringForTempTable objects
	Consultingwerk.IQueryRowIdentifier NewQueryRowIdentifier ()	Overridable factory method to create an instance of the IQueryRowIdentifier class
	OnAfterSaveChanges (EventArgs)	Raises the AfterSaveChanges
	OnAfterSavingRowChanges (SaveRowChangesEventArgs)	Raises the AfterSavingRowChanges event
	OnBeforeSaveChanges (EventArgs)	Raises the BeforeSaveChanges
	OnBeforeSavingRowChanges (SaveRowChangesEventArgs)	Raises the BeforeSavingRowChanges event
	OnHandleCommitError (HandleCommitErrorEventArgs)	Raises the HandleCommitError
	OnHandleCommitSysError (HandleCommitErrorEventArgs)	Raises the HandleCommitSysError
	CHARACTER ParentRelationSourceQueryString (handle)	Returns the query string matching the DATA-RELATION field pairs referencing the source fields on the parent table
	Consultingwerk.IQueryExpression ParseTopBufferRequestQuery (IFetchDataRequest)	Parses the Query of the top-buffer from the current request
	ProcessFetchDataRequestVariables (IFetchDataRequest)	Expands variables in the FetchDataRequest:Queries
	RepositionBackwards (handle, integer)	Reposition the given query backwards by the given number of records
	ROWID RepositionBackwards (handle, rowid[], integer)	Evaluates the ROWID from which the ProDataset FILL operation needs to start on a backwards fill operation
	SaveBuffer (handle)	Called from saveChanges to process changes for a single DataSet temp-table buffer.
	SaveChanges ()	Save changes to physical storage
	SaveRowChanges (handle)	Overridable method that executes SAVE-ROW-CHANGES on the before buffer
	SetDatasetBufferCallback (handle, character, character)	Sets's a ProDataset Buffer Callback-Method (BEFORE-FILL, AFTER-FILL, BEFORE-ROW-FILL, ...)
	SetDatasetBufferCallback (handle, character, character, Object)	Sets's a ProDataset Buffer Callback-Method (BEFORE-FILL, AFTER-FILL, BEFORE-ROW-FILL, ...)
	SetDatasetCallback (character, character)	Sets's a ProDataset Callback-Method (BEFORE-FILL, AFTER-FILL)
	SetDatasetCallback (character, character, Object)	Sets's a ProDataset Callback-Method (BEFORE-FILL, AFTER-FILL)
	Consultingwerk.IQueryRowIdentifier SkipRecords (integer, handle)	Returns the Query Row Identifier (ROWID) to be used when navigating that DATA-SOURCE query based on the Skip argument of the FetchDataRequest
	Consultingwerk.IQueryRowIdentifier SkipRecords (integer, handle, logical)	Returns the Query Row Identifier (ROWID) to be used when navigating that DATA-SOURCE query based on the Skip argument of the FetchDataRequest
A	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)
	CHARACTER SourceColumn2 (character, character)	Wrapper to the SourceColumn method - ensures that Data-Sources are attached
A	CHARACTER SourceDefaultQuery (character)	Returns the base query string used to retrieve data for the temp tables. This query string will be appended by the query provided by the consumer (FetchDataRequest object).
	SplitInnerJoinLevelFragment (character, character, character, character)	Splits the base query string returned by SourceDefaultQuery for a single temp-table into the primary source buffer name, the primary buffer's WHERE expression (without the leading WHERE keyword), and the auxiliary-join remainder.
	CHARACTER StripQueryEnvelope (character)	Strips the leading "for [each] " envelope and trailing " indexed-reposition" from a query string.
	SuggestDataSourceIndex (handle, character)	Method allows enforcing specific indexes when populating child record of a data-relation. When the parent buffer and the child buffer are FILL'ed during the ProDataset:FILL() operation, we ensure the given index
	VerifyRequestTables (character, IFetchDataRequest)	Verifies tables from the current FetchDataRequest

Top Constructor Summary

	Options	Name	Purpose
		DataAccess ()	Static Constructor of the DataAccess class
		DataAccess (handle)	Constructor of the DataAccess objects

Top Event Summary

	Options	Name	Purpose
		AfterSaveChanges (Object, EventArgs)	Raised at the end of SaveChanges - within the database transaction block
		AfterSavingRowChanges (Object, SaveRowChangesEventArgs)	Event raised after the execution of the SAVE-ROW-CHANGES method for an individual record in the DataAccessObject
		BeforeSaveChanges (Object, EventArgs)	Raised at the beginning of SaveChanges - within the database transaction block
		BeforeSavingRowChanges (Object, SaveRowChangesEventArgs)	Event raised before the execution of the SAVE-ROW-CHANGES method for an individual record in the DataAccessObject
		HandleCommitError (Object, HandleCommitErrorEventArgs)	Raised to allow custom handling of AppError's (Application errors, e.g. from DB triggers) raised while performing the SaveRowChanges method
		HandleCommitSysError (Object, HandleCommitErrorEventArgs)	Raised to allow custom handling of SysError's (Progress runtime errors) raised while performing the SaveRowChanges method

Top Property Summary

	Options	Name	Purpose
		Consultingwerk.Framework.Collections.CharacterDictionary AssignSkipDictionary
		CHARACTER AssignSkipList
		LOGICAL CheckDataTypeConversionForChildRelations
		CHARACTER CUSTOM_LOG_ENTRY
		HANDLE DatasetHandle
		LOGICAL DataSourcesAttached
		CHARACTER DefinedBufferNames
		CHARACTER FetchDataArgument
		Progress.Lang.Object FetchDataArguments
		Consultingwerk.OERA.IFetchDataRequest FetchDataRequest
		LOGICAL FilterUsingInnerJoin
		LOGICAL ForceApplyQueryOnChildTables
		LOGICAL IgnoreMissingDataSourceOnSaveChanges
		LOGICAL InFetchDataByKeyTable
		LOGICAL InFetchDataByTempTable
		LOGICAL LogFetchDataDetails
		LOGICAL PrepareJoinedChildTableQueries
		Consultingwerk.OERA.QueryPurposeEnum QueryPurpose
		Consultingwerk.OERA.Enum.RequestTypeEnum RequestType
		CHARACTER SourceBufferNames
		CHARACTER SourceTableNames
		LOGICAL ThrowErrorsOnFillFailed
		LOGICAL UseForwardOnlyQueries
		LOGICAL ValidateRestartRowid

Method Detail

Top

ActivateDefaultRelations ()

Purpose:	Enables the given ProDataset relations. Disables all other
	parent-relations of the relation's child buffer

Top

ActivateRelations (character)

Purpose:	Enables the given ProDataset relations. Disables all other
	parent-relations of the relation's child buffer
Notes:	Supports a comma-delimited list of relations

Parameters:
pcRelationNames	CHARACTER
	The name of the relation to enable

Top

AssignKeyFieldValues (handle)

Purpose:	Invoked by DataAccess:CommitChanges within the database transaction
	to optionally assign key field values for new records
Notes:	Provides a hook to assign key fields for new records before the
	changes (create) are written to the database. The default implementation
	of this method does nothing. Override this method to implement specific
	code

Parameters:
phBeforeBuffer	HANDLE
	The handle of the before buffer

Top

AssignKeyValue (handle, INameValuesPair, integer)

Purpose:	Assigns the value at index piIndex of a Name...ValuesPair instance
	to the corresponding field in the temp-table buffer
Notes:	SCL-5229

Parameters:
phBuffer	HANDLE
	The buffer handle of the record to assign to
poKey	Consultingwerk.OERA.INameValuesPair
	The INameValuesPair instance providing the values
piIndex	INTEGER
	The 1-based index of the value to assign

Top

LOGICAL AttachDataSource (handle, handle, character)

Purpose:	Attaches a data-source object to a temp-table buffer in a ProDataSet
	object
Notes:	Filters out any white space character from the field lists to allow
	for human readable source code in the DataAccess classes
	AttachDataSources method

Parameters:
phDatasetBuffer	HANDLE
	The handle of the ProDataset Buffer
phDataSource	HANDLE
	The handle of the DATA-SOURCE object
pcPairsList	CHARACTER
	pairs-list An optional character expression that evaluates to a comma-delimited list of field name pairs that specify a mapping between different field names in the data-source object buffer and the ProDataSet temp-table buffer
Returns	LOGICAL
	Logical return value of the ATTACH-DATA-SOURCE method

Top

LOGICAL AttachDataSource (handle, handle, character, character)

Purpose:	Attaches a data-source object to a temp-table buffer in a ProDataSet
	object
Notes:	Filters out any white space character from the field lists to allow
	for human readable source code in the DataAccess classes
	AttachDataSources method

Parameters:
phDatasetBuffer	HANDLE
	The handle of the ProDataset Buffer
phDataSource	HANDLE
	The handle of the DATA-SOURCE object
pcPairsList	CHARACTER
	pairs-list An optional character expression that evaluates to a comma-delimited list of field name pairs that specify a mapping between different field names in the data-source object buffer and the ProDataSet temp-table buffer
pcExceptList	CHARACTER
	An optional character expression that evaluates to a comma-separated list of fields in the ProDataSet object buffer that will not be populated with data from the data source (that is, fields to exclude). Use this option when it is easier to specify fields to exclude rather than include. You can specify except-fields or include-fields, but not both
Returns	LOGICAL
	Logical return value of the ATTACH-DATA-SOURCE method

Top

LOGICAL AttachDataSource (handle, handle, character, character, character)

Purpose:	Attaches a data-source object to a temp-table buffer in a ProDataSet
	object
Notes:	Filters out any white space character from the field lists to allow
	for human readable source code in the DataAccess classes
	AttachDataSources method

Parameters:
phDatasetBuffer	HANDLE
	The handle of the ProDataset Buffer
phDataSource	HANDLE
	The handle of the DATA-SOURCE object
pcPairsList	CHARACTER
	pairs-list An optional character expression that evaluates to a comma-delimited list of field name pairs that specify a mapping between different field names in the data-source object buffer and the ProDataSet temp-table buffer
pcExceptList	CHARACTER
	An optional character expression that evaluates to a comma-separated list of fields in the ProDataSet object buffer that will not be populated with data from the data source (that is, fields to exclude). Use this option when it is easier to specify fields to exclude rather than include. You can specify except-fields or include-fields, but not both
pcIncludeFields	CHARACTER
	An optional character expression that evaluates to a comma-separated list of fields to include in the ProDataSet object buffer, as an alternative to specifying fields to exclude in except-fields. Use this option when it is easier to specify fields to include rather than exclude. You can specify include-fields or except-fields, but not both. If you specify include-fields, you must set except-fields to the Unknown value (?)
Returns	LOGICAL
	Logical return value of the ATTACH-DATA-SOURCE method

Top

LOGICAL AttachDataSource (handle, IBufferDataSource)

Purpose:	Attaches a data-source object generated by an BufferDataSource
	instance to a temp-table buffer in a ProDataSet object
Notes:	Filters out any white space character from the field lists to allow
	for human readable source code in the DataAccess classes
	AttachDataSources method

Parameters:
phDatasetBuffer	HANDLE
	The handle of the ProDataset Buffer
poDataSource	Consultingwerk.OERA.IBufferDataSource
	The reference to the the BufferDataSource instance that manages a data-source object handle
Returns	LOGICAL
	Logical return value of the ATTACH-DATA-SOURCE method

Top

LOGICAL AttachDataSource (handle, IBufferDataSource, character)

Purpose:	Attaches a data-source object generated by an BufferDataSource
	instance to a temp-table buffer in a ProDataSet object
Notes:	Filters out any white space character from the field lists to allow
	for human readable source code in the DataAccess classes
	AttachDataSources method

Parameters:
phDatasetBuffer	HANDLE
	The handle of the ProDataset Buffer
poDataSource	Consultingwerk.OERA.IBufferDataSource
	The reference to the the BufferDataSource instance that manages a data-source object handle
pcPairsList	CHARACTER
	pairs-list An optional character expression that evaluates to a comma-delimited list of field name pairs that specify a mapping between different field names in the data-source object buffer and the ProDataSet temp-table buffer
Returns	LOGICAL
	Logical return value of the ATTACH-DATA-SOURCE method

Top

LOGICAL AttachDataSource (handle, IBufferDataSource, character, character)

Purpose:	Attaches a data-source object generated by an BufferDataSource
	instance to a temp-table buffer in a ProDataSet object
Notes:	Filters out any white space character from the field lists to allow
	for human readable source code in the DataAccess classes
	AttachDataSources method

Parameters:
phDatasetBuffer	HANDLE
	The handle of the ProDataset Buffer
poDataSource	Consultingwerk.OERA.IBufferDataSource
	The reference to the the BufferDataSource instance that manages a data-source object handle
pcPairsList	CHARACTER
	pairs-list An optional character expression that evaluates to a comma-delimited list of field name pairs that specify a mapping between different field names in the data-source object buffer and the ProDataSet temp-table buffer
pcExceptList	CHARACTER
	An optional character expression that evaluates to a comma-separated list of fields in the ProDataSet object buffer that will not be populated with data from the data source
Returns	LOGICAL
	Logical return value of the ATTACH-DATA-SOURCE method

Top

LOGICAL AttachDataSource (handle, IBufferDataSource, character, character, character)

Purpose:	Attaches a data-source object generated by an BufferDataSource
	instance to a temp-table buffer in a ProDataSet object
Notes:	Filters out any white space character from the field lists to allow
	for human readable source code in the DataAccess classes
	AttachDataSources method

Parameters:
phDatasetBuffer	HANDLE
	The handle of the ProDataset Buffer
poDataSource	Consultingwerk.OERA.IBufferDataSource
	The reference to the the BufferDataSource instance that manages a data-source object handle
pcPairsList	CHARACTER
	pairs-list An optional character expression that evaluates to a comma-delimited list of field name pairs that specify a mapping between different field names in the data-source object buffer and the ProDataSet temp-table buffer
pcExceptList	CHARACTER
	An optional character expression that evaluates to a comma-separated list of fields in the ProDataSet object buffer that will not be populated with data from the data source
pcIncludeList	CHARACTER
	An optional character expression that evaluates to a comma-separated list of fields to include in the ProDataSet object buffer, as an alternative to specifying fields to exclude in except-fields.
Returns	LOGICAL
	Logical return value of the ATTACH-DATA-SOURCE method

Top

AttachDataSources ()

Purpose:	Attaches the DATA-SOURCE objects to the ProDataset Buffers
Notes:	ABSTRACT method in Consultingwerk.OERA.DataAccess, overridden in
	actual DataAccess objects
	Invoked in FetchData and SaveChanges

Top

CHARACTER BuildDataSourceQueryString (handle, IFetchDataRequest, character)

Purpose:	Returns the Query String to be used for the DATA-SOURCE of a ProDataset
	member buffer
Notes:	Wrapper to the access to the DSQueryString class to simplify overriding
	the query manipulation in a custom Data Access class or customer
	DataAccess base class override
	This method is used to provide the query string for non top-level buffers
	The returned Query String is based on the Query String that was provided
	(by the consumer) and the Source Default Query of the Data Access object

Parameters:
phBufferHandle	HANDLE
	The Handle of the ProDataset member buffer
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The FetchDataRequest object of the current request
pcQueryString	CHARACTER
	The query string provided by the consumer
Returns	CHARACTER
	The Query String to be used for the data source of the ProDataset member buffer

Top

CHARACTER BuildDataSourceQueryString (handle, IFetchDataRequest, IQueryExpressionWithSort)

Purpose:	Returns the Query String to be used for the DATA-SOURCE of a ProDataset
	member buffer
Notes:	Wrapper to the access to the DSQueryString class to simplify overriding
	the query manipulation in a custom Data Access class or customer
	DataAccess base class override
	This method is used to provide the query string for non top-level buffers
	The returned Query String is based on the Query String that was provided
	(by the consumer) and the Source Default Query of the Data Access object

Parameters:
phBufferHandle	HANDLE
	The Handle of the ProDataset member buffer
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The FetchDataRequest object of the current request
poQuery	Consultingwerk.IQueryExpressionWithSort
	The query expression provided by the consumer
Returns	CHARACTER
	The Query String to be used for the data source of the ProDataset member buffer

Top

Consultingwerk.OERA.BufferDataSource BuildInnerJoinDataSource (integer, integer, character)

Purpose:	Builds and returns an initialized BufferDataSource carrying the
	source buffers needed by a single inner-join level fill (SCL-2351).
Notes:	Buffer order in the BufferDataSource matches the visit order
	produced by ComputeLevelVisitOrder, so the QUERY-PREPARE string
	can reference buffers in the same order. Each level contributes
	one BufferSpec for its primary source buffer (with InnerJoin to
	the previous level's primary) plus one BufferSpec per auxiliary
	buffer (with InnerJoin to this level's primary).

Parameters:
piLevel	INTEGER
	The level being filled (1-based)
piMaxFilteredLevel	INTEGER
	The deepest level that carries a non-empty user filter
pcQueries	CHARACTER
	CHR(1)-delimited per-level user filter expressions
Returns	Consultingwerk.OERA.BufferDataSource
	The initialized BufferDataSource

Top

CHARACTER BuildInnerJoinLevelQuery (integer, integer, character, character, character, character, character)

Purpose:	Builds the QUERY-PREPARE string for an inner-join level fill
	(SCL-2351).
Notes:	The query visits source buffers in the order returned by
	ComputeLevelVisitOrder. The OUTER for-each carries the level's
	merged WHERE; subsequent levels are chained via "first <primary>"
	with a source-to-source relation join. For piLevel > 1 (cascade
	fill) the OUTER additionally references the parent temp-table
	buffer (e.g. "Order.CustNum = eCustomer.CustNum"). USE-INDEX is
	applied when a buffer has BOTH a relation join AND a user filter
	(avoiding the alphabetical-index fallback of the optimizer).

Parameters:
piLevel	INTEGER
	The level being filled (1-based)
piMaxFilteredLevel	INTEGER
	The deepest level with a non-empty user filter
pcTempTableNames	CHARACTER
	Comma-separated temp-table names per level
pcParentJoinExprs	CHARACTER
	CHR(1)-delimited source-to-source parent-relation joins per level
pcParentTempJoins	CHARACTER
	CHR(1)-delimited source-to-temp-table parent-relation joins per level
pcFkIndexes	CHARACTER
	CHR(1)-delimited foreign-key index names per level
pcQueries	CHARACTER
	CHR(1)-delimited per-level user filter expressions
Returns	CHARACTER
	The composed QUERY-PREPARE string

Top

CanFind (CanFindParameter)

Purpose:	Returns a TRUE value if a record is found that meets the specified
	FIND criteria; otherwise it returns FALSE. CAN-FIND does not make
	the record available to the Business Entity or it's caller.
Notes:	Result will be assigned to the Result property of the CanFindParameter
	instance

Parameters:
poParameter	Consultingwerk.OERA.CanFindParameter
	The CanFindParameter with the parameters for this call

Top

CaptureInnerJoinLevelMetadata (handle, integer, character, character, character, character)

Purpose:	Captures per-level metadata required by the inner-join FetchData
	path (SCL-2351) before the static data-sources are detached.
Notes:	All CHR(1)-delimited outputs have one entry per level (level 1's
	entry is always empty for the parent-relation outputs).
	ParentRelationSourceQueryString, InnerJoinSourceRelationExpression
	and ForeignKeyIndexForLevel all rely on the buffer's
	DATA-SOURCE-COMPLETE-MAP through SourceColumn, so this method
	must be invoked BEFORE the static data-sources are detached.

Parameters:
phDataset	HANDLE
	The dataset handle
piLevels	INTEGER
	The number of temp-table levels in the dataset
pcTempTableNames	CHARACTER
	OUTPUT Comma-separated list of temp-table buffer names per level
pcParentJoinExprs	CHARACTER
	OUTPUT CHR(1)-delimited source-to-source parent-relation joins
pcParentTempJoins	CHARACTER
	OUTPUT CHR(1)-delimited source-to-temp-table parent-relation joins (for log output)
pcFkIndexes	CHARACTER
	OUTPUT CHR(1)-delimited foreign-key index names per level (empty entries when none found)

Top

CheckForRecursiveRelationWithQuery ()

Purpose:	Checks if the ProDataset contains recursive relations and
	the top-level-buffer is using a query with the DATA-SOURCE
Notes:	SCL-3449 / SCLSUP-399

Top

CHARACTER CombineWhereAnd (character, character)

Purpose:	Returns the logical AND of two WHERE expressions, each
	parenthesized; either side may be empty.
Notes:	SCL-2351. Helper for the inner-join query composition. When
	both arguments are empty the result is empty. When one
	argument is empty the other is returned wrapped in parentheses.

Parameters:
pcLeft	CHARACTER
	The left WHERE expression (without leading WHERE keyword)
pcRight	CHARACTER
	The right WHERE expression (without leading WHERE keyword)
Returns	CHARACTER
	The combined expression

Top

CommitChanges (handle)

Purpose:	This method is called from SaveChanges in the DA
	to do the actual database commit and any transaction-related
	validation logic for a buffer.
Notes:	This is taken directly from the OERI.
	- Note that in this sample that illustrates support for distributed
	business logic the DA saves the whole dataset in SaveChanges, so
	this is not currently called from the BE.
	- The event names are the same as in the OERI. The word "Trans"
	is somewhat misleading as the DA need to support large transactions.
	One could consider using a name that indicates that this is a row
	event instead.

Parameters:
phBuffer	HANDLE
	The handle of the after buffer to commit

Top

INTEGER ComputeLevelVisitOrder (integer, integer, character)

Purpose:	Computes the level visit order for the inner-join data-source
	query of a single level fill (SCL-2351).
Notes:	Returns an INTEGER EXTENT listing the levels in the order their
	source buffers appear in the prepared query.
	- For piLevel = 1 with at least one descendant filter (piMax > 1):
	visit order is [outer, descendants..., ancestors...] where
	outer = shallowest descendant level that carries a non-empty
	user filter (the OUTER for-each iterates the most selective
	predicate). Descendants are visited piOuter + 1 .. piMax,
	then ancestors piOuter - 1 .. 1.
	- For piLevel > 1 (descendant cascade fill) or piLevel = 1
	without descendant filter: visit order is the natural linear
	order piLevel .. piMax.

Parameters:
piLevel	INTEGER
	The level being filled (1-based)
piMaxFilteredLevel	INTEGER
	The deepest level that carries a non-empty user filter
pcQueries	CHARACTER
	CHR(1)-delimited per-level user filter expressions
Returns	INTEGER
	INTEGER EXTENT of levels in visit order

Top

INTEGER ComputeMaxFilteredLevel (IFetchDataRequest, integer)

Purpose:	Returns the deepest level index (1-based) that carries a non-
	empty user filter in the IFetchDataRequest:Queries CHR(1)
	delimited list.
Notes:	SCL-2351. Determines how far the inner-join descendant chain
	must extend - deeper levels with no filter add nothing to the
	inner-join cardinality and are skipped.

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The fetch-data request
piLevels	INTEGER
	The total number of levels in the dataset
Returns	INTEGER
	The deepest filtered level (0 when no level carries a filter)

Top

CountResultRecords (ICountRecordsRequest)

Purpose:	Counts the number of result records in the data source query
Notes:

Parameters:
poFetchDataRequest	Consultingwerk.OERA.ICountRecordsRequest
	The ICountRecordsRequest that also implements IFetchDataRequest

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
pcTables	CHARACTER
	A database table name or comma delimited list of database table names
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
pcTable1	CHARACTER
	The first database table name
pcTable2	CHARACTER
	The second database table name
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
pcTable1	CHARACTER
	The first database table name
pcTable2	CHARACTER
	The second database table name
pcTable3	CHARACTER
	The third database table name
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
pcTable1	CHARACTER
	The first database table name
pcTable2	CHARACTER
	The second database table name
pcTable3	CHARACTER
	The third database table name
pcTable4	CHARACTER
	The fourth database table name
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
pcTable1	CHARACTER
	The first database table name
pcTable2	CHARACTER
	The second database table name
pcTable3	CHARACTER
	The third database table name
pcTable4	CHARACTER
	The fourth database table name
pcTable5	CHARACTER
	The fifth database table name
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
pcTable1	CHARACTER
	The first database table name
pcTable2	CHARACTER
	The second database table name
pcTable3	CHARACTER
	The third database table name
pcTable4	CHARACTER
	The fourth database table name
pcTable5	CHARACTER
	The fifth database table name
pcTable6	CHARACTER
	The sixth database table name
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
pcTable1	CHARACTER
	The first database table name
pcTable2	CHARACTER
	The second database table name
pcTable3	CHARACTER
	The third database table name
pcTable4	CHARACTER
	The fourth database table name
pcTable5	CHARACTER
	The fifth database table name
pcTable6	CHARACTER
	The sixth database table name
pcTable7	CHARACTER
	The seventh database table name
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character, character)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
pcTable1	CHARACTER
	The first database table name
pcTable2	CHARACTER
	The second database table name
pcTable3	CHARACTER
	The third database table name
pcTable4	CHARACTER
	The fourth database table name
pcTable5	CHARACTER
	The fifth database table name
pcTable6	CHARACTER
	The sixth database table name
pcTable7	CHARACTER
	The seventh database table name
pcTable8	CHARACTER
	The eighth database table name
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character, character, character)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
pcTable1	CHARACTER
	The first database table name
pcTable2	CHARACTER
	The second database table name
pcTable3	CHARACTER
	The third database table name
pcTable4	CHARACTER
	The fourth database table name
pcTable5	CHARACTER
	The fifth database table name
pcTable6	CHARACTER
	The sixth database table name
pcTable7	CHARACTER
	The seventh database table name
pcTable8	CHARACTER
	The eighth database table name
pcTable9	CHARACTER
	The ninth database table name
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character, character, character, character)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
pcTable1	CHARACTER
	The first database table name
pcTable2	CHARACTER
	The second database table name
pcTable3	CHARACTER
	The third database table name
pcTable4	CHARACTER
	The fourth database table name
pcTable5	CHARACTER
	The fifth database table name
pcTable6	CHARACTER
	The sixth database table name
pcTable7	CHARACTER
	The seventh database table name
pcTable8	CHARACTER
	The eighth database table name
pcTable9	CHARACTER
	The ninth database table name
pcTable10	CHARACTER
	The tenth database table name
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
poBufferSpecs	Consultingwerk.OERA.IBufferSpec
	A buffer specification
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
poBufferSpec1	Consultingwerk.OERA.IBufferSpec
	The first buffer specification
poBufferSpec2	Consultingwerk.OERA.IBufferSpec
	The second buffer specification
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
poBufferSpec1	Consultingwerk.OERA.IBufferSpec
	The first buffer specification
poBufferSpec2	Consultingwerk.OERA.IBufferSpec
	The second buffer specification
poBufferSpec3	Consultingwerk.OERA.IBufferSpec
	The third buffer specification
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
poBufferSpec1	Consultingwerk.OERA.IBufferSpec
	The first buffer specification
poBufferSpec2	Consultingwerk.OERA.IBufferSpec
	The second buffer specification
poBufferSpec3	Consultingwerk.OERA.IBufferSpec
	The third buffer specification
poBufferSpec4	Consultingwerk.OERA.IBufferSpec
	The fourth buffer specification
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
poBufferSpec1	Consultingwerk.OERA.IBufferSpec
	The first buffer specification
poBufferSpec2	Consultingwerk.OERA.IBufferSpec
	The second buffer specification
poBufferSpec3	Consultingwerk.OERA.IBufferSpec
	The third buffer specification
poBufferSpec4	Consultingwerk.OERA.IBufferSpec
	The fourth buffer specification
poBufferSpec5	Consultingwerk.OERA.IBufferSpec
	The fifth buffer specification
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
poBufferSpec1	Consultingwerk.OERA.IBufferSpec
	The first buffer specification
poBufferSpec2	Consultingwerk.OERA.IBufferSpec
	The second buffer specification
poBufferSpec3	Consultingwerk.OERA.IBufferSpec
	The third buffer specification
poBufferSpec4	Consultingwerk.OERA.IBufferSpec
	The fourth buffer specification
poBufferSpec5	Consultingwerk.OERA.IBufferSpec
	The fifth buffer specification
poBufferSpec6	Consultingwerk.OERA.IBufferSpec
	The sixth buffer specification
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
poBufferSpec1	Consultingwerk.OERA.IBufferSpec
	The first buffer specification
poBufferSpec2	Consultingwerk.OERA.IBufferSpec
	The second buffer specification
poBufferSpec3	Consultingwerk.OERA.IBufferSpec
	The third buffer specification
poBufferSpec4	Consultingwerk.OERA.IBufferSpec
	The fourth buffer specification
poBufferSpec5	Consultingwerk.OERA.IBufferSpec
	The fifth buffer specification
poBufferSpec6	Consultingwerk.OERA.IBufferSpec
	The sixth buffer specification
poBufferSpec7	Consultingwerk.OERA.IBufferSpec
	The seventh buffer specification
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
poBufferSpec1	Consultingwerk.OERA.IBufferSpec
	The first buffer specification
poBufferSpec2	Consultingwerk.OERA.IBufferSpec
	The second buffer specification
poBufferSpec3	Consultingwerk.OERA.IBufferSpec
	The third buffer specification
poBufferSpec4	Consultingwerk.OERA.IBufferSpec
	The fourth buffer specification
poBufferSpec5	Consultingwerk.OERA.IBufferSpec
	The fifth buffer specification
poBufferSpec6	Consultingwerk.OERA.IBufferSpec
	The sixth buffer specification
poBufferSpec7	Consultingwerk.OERA.IBufferSpec
	The seventh buffer specification
poBufferSpec8	Consultingwerk.OERA.IBufferSpec
	The eighth buffer specification
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
poBufferSpec1	Consultingwerk.OERA.IBufferSpec
	The first buffer specification
poBufferSpec2	Consultingwerk.OERA.IBufferSpec
	The second buffer specification
poBufferSpec3	Consultingwerk.OERA.IBufferSpec
	The third buffer specification
poBufferSpec4	Consultingwerk.OERA.IBufferSpec
	The fourth buffer specification
poBufferSpec5	Consultingwerk.OERA.IBufferSpec
	The fifth buffer specification
poBufferSpec6	Consultingwerk.OERA.IBufferSpec
	The sixth buffer specification
poBufferSpec7	Consultingwerk.OERA.IBufferSpec
	The seventh buffer specification
poBufferSpec8	Consultingwerk.OERA.IBufferSpec
	The eighth buffer specification
poBufferSpec9	Consultingwerk.OERA.IBufferSpec
	The ninth buffer specification
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec)

Purpose:	Creates a BufferDataSource
Notes:

Parameters:
poBufferSpec1	Consultingwerk.OERA.IBufferSpec
	The first buffer specification
poBufferSpec2	Consultingwerk.OERA.IBufferSpec
	The second buffer specification
poBufferSpec3	Consultingwerk.OERA.IBufferSpec
	The third buffer specification
poBufferSpec4	Consultingwerk.OERA.IBufferSpec
	The fourth buffer specification
poBufferSpec5	Consultingwerk.OERA.IBufferSpec
	The fifth buffer specification
poBufferSpec6	Consultingwerk.OERA.IBufferSpec
	The sixth buffer specification
poBufferSpec7	Consultingwerk.OERA.IBufferSpec
	The seventh buffer specification
poBufferSpec8	Consultingwerk.OERA.IBufferSpec
	The eighth buffer specification
poBufferSpec9	Consultingwerk.OERA.IBufferSpec
	The ninth buffer specification
poBufferSpec10	Consultingwerk.OERA.IBufferSpec
	The tenth buffer specification
Returns	Consultingwerk.OERA.IBufferDataSource
	The new BufferDataSource instance

Top

CustomizeFetchDataRequest (IFetchDataRequest)

Purpose:	Hook method to support customization the IFetchDataRequest or ICountRecordsRequest
Notes:	Centralized location to customize queries for FetchData and CountResultRecords

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The IFetchDataRequest instance to customize

Top

LOGICAL DatasetBufferFill (handle, IFetchDataRequest)

Purpose:	Invokes the FILL method of a ProDataset member buffer
Notes:	Allows overriding this method in custom variants of the Data Access
	Errors thrown from or raised in the FILL call-back methods of the
	DataAccess class (SET-CALLBACK) will stop the Dataset from getting
	filled / filled further. However errors thrown from the call-back
	methods are not thrown from the FILL() method further up into a
	catch block or to the client.
	See http://knowledgebase.progress.com/articles/Article/P188375

Parameters:
phBuffer	HANDLE
	The handle of the proDataset
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The FetchDataRequest instance with the parameters for the current read
Returns	LOGICAL
	If the FILL is successful, this method returns TRUE. Otherwise, it returns FALSE.

Top

LOGICAL DatasetFill (handle, IFetchDataRequest)

Purpose:	Invokes the ProDataset FILL method
Notes:	Allows overriding this method in custom variants of the Data Access
	Errors thrown from or raised in the FILL call-back methods of the
	DataAccess class (SET-CALLBACK) will stop the Dataset from getting
	filled / filled further. However errors thrown from the call-back
	methods are not thrown from the FILL() method further up into a
	catch block or to the client.
	See http://knowledgebase.progress.com/articles/Article/P188375

Parameters:
phDataset	HANDLE
	The handle of the ProDataset
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The FetchDataRequest instance with the parameters for the current read
Returns	LOGICAL
	If the FILL is successful, this method returns TRUE. Otherwise, it returns FALSE.

Top

DefineReadEvents ()

Purpose:	TO-DO: Subscribe to ProDataset Event Handlers using SET-CALLBACK
	as needed
Notes:	ABSTRACT method in Consultingwerk.OERA.DataAccess, overridden in
	actual DataAccess objects
	Invoked in FetchData

Top

DetachDataSources ()

Purpose:	Detaches the DATA-SOURCE objects to the ProDataset Buffers
Notes:	ABSTRACT method in Consultingwerk.OERA.DataAccess, overridden in
	actual DataAccess objects
	Invoked in FetchData and SaveChanges

Top

EnableDataAccessQueryLogging ()

Purpose:	Enables DataAccessLogging
Notes:

Top

CHARACTER ExpandTables (character)

Purpose:	Expands the FetchDataRequest:Tables parameter, in case it contains
	the * wild-card character
Notes:

Parameters:
pcTables	CHARACTER
	The initial Tables parameter
Returns	CHARACTER
	The tables parameter with the wild-cards expanded

Top

FetchData (IFetchDataRequest)

Purpose:	Fetch data from the data source
Notes:	poFetchDataRequest:Context property is used to control batching
	(forward/backwards) and the FindRowWhere/PreFetchOnFind
	The first entry by CHR(1) in the Context is CHR(2) delimited:
	1. Entry: RESTART-ROWID(s) - CHR(5) Delimited
	2. Entry: Find String
	3. Entry: PrefetchOnFind Value
	The poFetchDataRequest parameter may also be passed in as a
	IFetchDataAccessRequest instance allowing further specific arguments
	to be passed that are only relevant to the DataAccess class

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The IFetchDataRequest object with the parameters for this call

Top

FetchDataByKeyTable (IFetchDataByKeyTableParameter)

Purpose:	Allows retrieve multiple DB records from a Business Entity based on
	a temp-table with key values
Notes:

Parameters:
poParameter	Consultingwerk.OERA.IFetchDataByKeyTableParameter
	The IFetchDataByKeyTableParameter with the data for this call

Top

FetchDataByKeyValues (FetchDataByKeysParameter)

Purpose:	Allows retrieve multiple DB records from a Business Entity based on
	extents of key values for one or more fields
Notes:	Builds a GenericFetchDataByKeyTableParameter from the
	FetchDataByKeysParameter and delegates to FetchDataByKeyTable.
	SCL-5229

Parameters:
poParameter	Consultingwerk.OERA.FetchDataByKeysParameter
	The FetchDataByKeysParameter with the data for this call

Top

FetchDataByStaticQuery (IFetchDataByStaticQueryRequest)

Purpose:	Fetches data for single table, using a static query
Notes:	This method always throws an exception, since only the concrete DataAccess classes know
	which Fetch* method uses which parameter type

Parameters:
poParameter	Consultingwerk.OERA.IFetchDataByStaticQueryRequest
	The query parameter object

Top

FetchDataByTempTable (table-handle, IFetchDataByTempTableParameter)

Purpose:	Supports retrieve multiple DB records from a Business Entity based on
	a join to an (external) temp-table
Notes:

Parameters:
phTable	TABLE-HANDLE
	The handle of the temp-table with which to perform a join while fetching data
poParameter	Consultingwerk.OERA.IFetchDataByTempTableParameter
	The IFetchDataByTempTableParameter with the data for this call

Top

FetchDataEmptyDataset (IFetchDataRequest)

Purpose:	Empties the Dataset before the request
Notes:	Optionally support for IFetchDataAccessRequest:AppendFetchData (SCL-1048)

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The IFetchDataRequest instance

Top

FetchDataFill (IFetchDataRequest, character, handle)

Purpose:	Invokes FILL on the Dataset or the given Dataset Buffer
Notes:

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The reference to the FetchDataRequest instance
pcTables	CHARACTER
	The request tables
phFillBuffer	HANDLE
	The (first) buffer to fill

Top

FetchDataFillFindRowWhereBatch (IFetchDataRequest, handle, integer, character[])

Purpose:	Verify that a FindRowWhere on the server does always return
	a full batch of records
Notes:

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The reference to the current IFetchDataRequest instance
phBuffer	HANDLE
	The handle of the fill-buffer
piBatchSize	INTEGER
	The batch-size
pcFillWhereStrings	CHARACTER
	The array of fill-where-strings

Top

FetchDataFillRepositionTables (IFetchDataRequest, character)

Purpose:	FILL's buffers with REPOSITION parent-relations
Notes:

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The reference to the current IFetchDataRequest instance
pcTables	CHARACTER
	The list of tables to populate

Top

FetchDataHandleErrorStatus ()

Purpose:	Handles ERROR-STATUS after the FetchData's FILL
Notes:

Top

FetchDataInnerJoins (IFetchDataRequest)

Purpose:	Implements the inner-join variant of FetchData (SCL-2351).
Notes:	Detaches the static data-sources attached by AttachDataSources(),
	builds dynamic BufferDataSource instances for each temp-table
	buffer that span the buffers of that temp-table and all its
	descendant temp-tables, attaches them and fills the ProDataset.
	The dynamic sources are released by FetchDataInnerJoinsCleanup
	from the FetchData FINALLY block.

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The IFetchDataRequest object with the parameters for this call

Top

FetchDataInnerJoinsCleanup ()

Purpose:	Releases the dynamic BufferDataSource instances built for the
	UseInnerJoins variant of FetchData.
Notes:	SCL-2351. Detaches the dynamic data-sources from the
	ProDataset buffers (so the FINALLY DetachDataSources call below
	becomes a no-op for those buffers) and deletes the
	BufferDataSource objects via the GarbageCollectorHelper.

Top

FetchDataInnerJoinsValidate (IFetchDataRequest)

Purpose:	Validates the applicability of the UseInnerJoins flag on the
	current request.
Notes:	SCL-2351. UseInnerJoins only makes sense when the Business Entity
	exposes more than a single temp-table and when the request
	contains at least one non-empty child/grand-child filter
	expression in the Queries property.

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The IFetchDataRequest object with the parameters for this call

Top

FetchDataInternal (IFetchDataRequest, logical)

Purpose:	Fetch data from the data source
Notes:	Internal version of the method. The attaching and de-attaching of
	the DataSources is no done in FetchData. The possible recursive call
	to fetch a complete LAST batch after FindRowWhere is calling into
	the method FetchDataInternal do not interfere with the attaching of
	the data-source's. SCL-621: This structure allows us to always detach
	the data-sources when they should still be around (left over due to
	missing FINALLY-Block execution after STOP-Condition

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The IFetchDataRequest object with the parameters for this call
plUseForwardOnlyQueries	LOGICAL
	Indicates whether the data-source queries should have FORWARD-ONLY = TRUE

Top

FetchDataLogNextRowid (handle)

Purpose:	Logs the NEXT-ROWID and LAST-BATCH property of the fill-buffer
Notes:

Parameters:
phFillBuffer	HANDLE
	The handle of the fill-buffer

Top

FetchDataLogRestartRowid (handle)

Purpose:	Logs the RESTART-ROWID of the fill-buffer
Notes:

Parameters:
phFillBuffer	HANDLE
	The handle of the fill-buffer

Top

FetchDataPrepareChildTableQuery (IFetchDataRequest, handle, integer, character)

Purpose:	Prepares the query for a child table
Notes:

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The IFetchDataRequest instance
phBuffer	HANDLE
	The buffer to prepare the Data Source query for
piTable	INTEGER
	The counter of the current table in the request
pcQueries	CHARACTER
	The list of query strings for all request tables

Top

FetchDataPrepareParentTableQuery (IFetchDataRequest, handle, integer, integer, character, IQueryRowIdentifier, character, FindRecordResult, handle)

Purpose:	Prepares the query for a parent table
Notes:

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The IFetchDataRequest instance
phBuffer	HANDLE
	The buffer to prepare the Data Source query for
piTable	INTEGER
	The counter of the current table in the request
piBatchSize	INTEGER
	The request's Batch Size
pcQueries	CHARACTER
	The list of query strings for all request tables
proRestartRowids	Consultingwerk.IQueryRowIdentifier
	INPUT-OUTPUT The reference to the IQueryRowIdentifier instance
pcFindString	CHARACTER
	OUTPUT The FIND String to return to the caller
poFindRecordResult	Consultingwerk.OERA.FindRecordResult
	OUTPUT The FindRecordResult to return to the caller
phQuery	HANDLE
	The handle of the data-source query

Top

FetchDataRestoreBatchSizes (integer[])

Purpose:	Restores the Batch-Size of the ProDataset buffers
Notes:

Parameters:
piBatchSizes	INTEGER
	The array with the ProDataset buffer's Batch-Sizes

Top

FetchDataSetBatchContext (handle, character)

Purpose:	Updates the batch context with the next-rowids
Notes:

Parameters:
phBuffer	HANDLE
	The handle of the first request buffer
pcContext	CHARACTER
	The batch context to update

Top

FetchDataSetFillMode (IFetchDataRequest, handle)

Purpose:	Sets the FILL-MODE for a Temp-Table Buffer in preparation for
	a FILL() method call
Notes:

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The reference to the IFetchDataRequest instance
phBuffer	HANDLE
	The handle of the current buffer

Top

FetchDataUpdateRequestContext (IFetchDataRequest, integer, character, IQueryRowIdentifier, character, FindRecordResult)

Purpose:	Updates the NextContext, PrevContext and BatchContext properties
	of the IFetchDataInstance
Notes:

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The reference to the IFetchDataRequest instance
piBatchSize	INTEGER
	The batch size
pcContext	CHARACTER
	The batch-context
proRestartRowids	Consultingwerk.IQueryRowIdentifier
	The restart-rowids
pcFindString	CHARACTER
	The FIND String
poFindRecordResult	Consultingwerk.OERA.FindRecordResult
	The result of the FIND operation

Top

INTEGER FindFirstTopLevelComma (character, integer)

Purpose:	Returns the position of the first top-level comma in a query
	fragment, skipping commas inside parentheses or string literals.
Notes:	SCL-2351. Helper for SplitInnerJoinLevelFragment to separate
	the primary buffer's clause from the auxiliary-join remainder.

Parameters:
pcBody	CHARACTER
	The query body (already stripped of the envelope)
piStart	INTEGER
	The 1-based scan starting position
Returns	INTEGER
	The 1-based position of the comma, or 0 when none is found

Top

CHARACTER FindIndexByLeadingFields (handle, character)

Purpose:	Finds the first index of a buffer's table whose leading fields
	match the given comma-separated list of field names.
Notes:	SCL-2351. Iterates BUFFER-HANDLE:INDEX-INFORMATION (i) for
	i = 1, 2, ... until the call returns the unknown value (which
	signals the end of the index list). The returned string has
	the format
	"<index-name>,<unique>,<primary>,<word>,<field1>,<asc>,<field2>,<asc>..."
	so the field names are at entries 5, 7, 9, ...
	Comparison is case-insensitive (ABL string compare semantics).

Parameters:
phBuffer	HANDLE
	The buffer-handle of the source table
pcLeadingFields	CHARACTER
	Comma-separated list of leading field names to match
Returns	CHARACTER
	The first matching index name, or empty string when no index matches

Top

ROWID FindRecord (character, handle, character, integer, integer)

Purpose:	Finds a record in the data source query and returns the ROWID ARRAY
	(used as RESTART-ROWID in FetchData)
Notes:	This method is kept for backwards compatibility as the FindRecord2
	method is now the actual working method

Parameters:
pcFindString	CHARACTER
	WHERE eCustomer.CustNum = 10
phBufferHandle	HANDLE
	The temp-table buffer handle
pcQueryString	CHARACTER
	The current data-source query string
piPrefetch	INTEGER
	The number of records to prefetch
piBatchSize	INTEGER
	The number of records to return to the client (total incl. prefetch)
Returns	ROWID
	The ROWID array of the records - that starts the resulting batch

Top

Consultingwerk.OERA.FindRecordResult FindRecord2 (character, handle, character, integer, integer)

Purpose:	Finds a record in the data source query and returns the ROWID ARRAY
	(used as RESTART-ROWID in FetchData)
Notes:	Defaults to THROW error on not found

Parameters:
pcFindString	CHARACTER
	WHERE eCustomer.CustNum = 10
phBufferHandle	HANDLE
	The temp-table buffer handle
pcQueryString	CHARACTER
	The current data-source query string
piPrefetch	INTEGER
	The number of records to prefetch
piBatchSize	INTEGER
	The number of records to return to the client (total incl. prefetch)
Returns	Consultingwerk.OERA.FindRecordResult
	The FindRecordResult with the array of rowids and the information if a previous batch is available

Top

Consultingwerk.OERA.FindRecordResult FindRecord2 (character, handle, character, integer, integer, logical)

Purpose:	Finds a record in the data source query and returns the ROWID ARRAY
	(used as RESTART-ROWID in FetchData)
Notes:

Parameters:
pcFindString	CHARACTER
	WHERE eCustomer.CustNum = 10
phBufferHandle	HANDLE
	The temp-table buffer handle
pcQueryString	CHARACTER
	The current data-source query string
piPrefetch	INTEGER
	The number of records to prefetch
piBatchSize	INTEGER
	The number of records to return to the client (total incl. prefetch)
plThrowOnNotFound	LOGICAL
	Logical value indicating if an error should be thrown when the record cannot be found
Returns	Consultingwerk.OERA.FindRecordResult
	The FindRecordResult with the array of rowids and the information if a previous batch is available, returns ? when no record was found and plThrowOnNotFound = FALSE

Top

Consultingwerk.OERA.FindRecordResult FindRecord2 (character, handle, IQueryExpressionWithSort, integer, integer, logical)

Purpose:	Finds a record in the data source query and returns the ROWID ARRAY
	(used as RESTART-ROWID in FetchData)
Notes:

Parameters:
pcFindString	CHARACTER
	WHERE eCustomer.CustNum = 10
phBufferHandle	HANDLE
	The temp-table buffer handle
poQuery	Consultingwerk.IQueryExpressionWithSort
	The current data-source query expression
piPrefetch	INTEGER
	The number of records to prefetch
piBatchSize	INTEGER
	The number of records to return to the client (total incl. prefetch)
plThrowOnNotFound	LOGICAL
	Logical value indicating if an error should be thrown when the record cannot be found
Returns	Consultingwerk.OERA.FindRecordResult
	The FindRecordResult with the array of rowids and the information if a previous batch is available, returns ? when no record was found and plThrowOnNotFound = FALSE

Top

FindSourceBuffer (handle, logical)

Purpose:	Locates the matching record in the first source buffer of the given
	Dataset Buffer
Notes:

Parameters:
phBuffer	HANDLE
	The handle of a (after or before) ProDataset buffer
plExclusiveLock	LOGICAL
	Logical value indicating if the record should be locked exclusively

Top

CHARACTER ForeignKeyIndexForLevel (handle)

Purpose:	Returns the name of the database index on the level's primary
	source buffer whose leading fields match the parent-relation
	foreign-key fields.
Notes:	SCL-2351. OpenEdge's query optimizer picks an index alphabetically
	when multiple equality predicates exist on indexed fields. In a
	descendant-fill query the FK predicate (e.g. OrderLine.OrderNum =
	eOrder.OrderNum) is far more selective than a filter predicate on
	an unrelated field (e.g. OrderLine.Itemnum = 5), so the inner-
	join query is annotated with USE-INDEX to force the FK index.
	The method translates the relation's child-side fields through
	SourceColumn to obtain the source-buffer field names, then walks
	the source table's _Index / _Index-Field meta-schema to find the
	first index whose leading fields match (case-insensitive). When
	no match is found (non-Progress DB, or no matching index) an
	empty string is returned and the caller emits no USE-INDEX hint.

Parameters:
phChildBuffer	HANDLE
	The handle of the child temp-table buffer
Returns	CHARACTER
	The index name to force via USE-INDEX, or empty string

Top

CHARACTER GetDefinedBufferName (character)

Purpose:	Finds a matching buffer name in the current dataset, and returns the defined buffer name
Notes:

Parameters:
pcName	CHARACTER
	The buffer name to find
Returns	CHARACTER
	The defined buffer name, or the input name, if none exists or could be found

Top

CHARACTER GetDefinedBufferName (integer)

Purpose:	Finds a matching buffer name in the current dataset, and returns the defined buffer name
Notes:

Parameters:
piIndex	INTEGER
	The index of the buffer in the dataset
Returns	CHARACTER
	The defined buffer name, or the dataset buffer name

Top

CHARACTER GetKeyDataType (INameValuesPair)

Purpose:	Returns the ABL primitive data type for a Name...ValuesPair instance
Notes:	SCL-5229

Parameters:
poKey	Consultingwerk.OERA.INameValuesPair
	The INameValuesPair instance to inspect
Returns	CHARACTER
	The ABL primitive data type as a character string

Top

INTEGER GetKeyValuesExtent (INameValuesPair)

Purpose:	Returns the extent of the Values property of a Name...ValuesPair
	instance based on its concrete type
Notes:	SCL-5229

Parameters:
poKey	Consultingwerk.OERA.INameValuesPair
	The INameValuesPair instance to inspect
Returns	INTEGER
	The extent of the Values property

Top

HandleKnownCommitErrors (SysError, character, handle)

Purpose:	Handles known commit errors and adds error messages to the before buffer
	Notes : Extracted from CommitChanges (SysError catch block)

Parameters:
poSysErr	Progress.Lang.SysError
	The SysError thrown by SAVE-ROW-CHANGES
pcReturnValue	CHARACTER
	The RETURN-VALUE after SAVE-ROW-CHANGES
phBeforeBuff	HANDLE
	The handle of the before buffer

Top

HandleRecordLockedError (handle, SysError)

Purpose:	Handles a record locked error invoked during the SAVE-ROW-CHANGES
	method
Notes:	Allows customization to the Progress default error message

Parameters:
phBeforeBuffer	HANDLE
	The handle to before buffer
poSysError	Progress.Lang.SysError
	The original error raised

Top

InitializeDataAccessQueryLogging ()

Purpose:	Initializes DataAccessLogging
Notes:

Top

CHARACTER InnerJoinSourceRelationExpression (handle)

Purpose:	Builds the inner-join WHERE expression that relates a child
	temp-table's source buffer(s) to its parent temp-table's source
	buffer(s), based on the dataset's data-relation foreign-fields.
Notes:	SCL-2351. Both sides of the expression are translated to source-
	buffer fields by consulting the buffers' DATA-SOURCE-COMPLETE-MAP
	via SourceColumn. Must be called BEFORE the static data-sources
	are detached.
	Differs from ParentRelationSourceQueryString in that the parent
	side is also translated to a source-buffer field reference
	instead of being left as a temp-table buffer reference.

Parameters:
phChildBuffer	HANDLE
	The handle of the child temp-table buffer
Returns	CHARACTER
	The composed expression, e.g. "Order.CustNum = Customer.CustNum"

Top

HANDLE InsertToDataSourceQuery (handle, IFetchDataRequest, character)

Purpose:	Creates a new Query to be used as a DATA-SOURCE for a ProDataset
	member buffer
Notes:	Wrapper to the access to the DSQueryString class to simplify overriding
	the query manipulation in a custom Data Access class or customer
	DataAccess base class override
	This Query is prepared based on the Query String that was provided
	(by the consumer) and the Source Default Query of the Data Access object

Parameters:
phBufferHandle	HANDLE
	The Handle of the ProDataset member buffer
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The FetchDataRequest object of the current request
pcQueryString	CHARACTER
	The query string provided by the consumer
Returns	HANDLE
	The handle of the Query that was created

Top

HANDLE InsertToDataSourceQuery (handle, IFetchDataRequest, IQueryExpressionWithSort)

Purpose:	Creates a new Query to be used as a DATA-SOURCE for a ProDataset
	member buffer
Notes:	Wrapper to the access to the DSQueryString class to simplify overriding
	the query manipulation in a custom Data Access class or customer
	DataAccess base class override
	This Query is prepared based on the Query String that was provided
	(by the consumer) and the Source Default Query of the Data Access object

Parameters:
phBufferHandle	HANDLE
	The Handle of the ProDataset member buffer
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The FetchDataRequest object of the current request
poQuery	Consultingwerk.IQueryExpressionWithSort
	The query expression with sort provided by the consumer
Returns	HANDLE
	The handle of the Query that was created

Top

InvokeCommitChangesCallback (CommitCallbackTypeEnum, handle)

Purpose:	Invokes a CommitChangesCallback
Notes:	Provides a central location to handle error thrown from these
	callback methods. By default errors thrown will be thrown to the
	caller. By overriding this method customers can CATCH errors and add
	them to the ProDataset buffer ERROR-STRING etc.

Parameters:
poCommitCallbackType	Consultingwerk.OERA.Enum.CommitCallbackTypeEnum
	The CommitCallbackTypeEnum value describing the callback to be invoked
phBeforeBuffer	HANDLE
	The handle of the before-buffer (to determine the ROW-STATE)

Top

LOGICAL IsQueryFlagPresent (character, character)

Purpose:	Returns if the passed in field (prefixed with the temp-table)
	is referenced in a list of query flag fields and is contained in the
	FetchDataRequest's QueryExpression
Notes:

Parameters:
pcFieldName	CHARACTER
	The name of the field to verify
pcQueryFlagFields	CHARACTER
	The name of the fields to compare with
Returns	LOGICAL
	Logical value indicating if the passed in field is referenced in a list of query flag fields and is contained in the FetchDataRequest's QueryExpression

Top

LogCurrentRowModifiedIssue (handle)

Purpose:	Logs details about "current row has been modified
	by another user to the current logfile
Notes:	Invoked by the SaveRowChanges method when error 11913 occurs
	and the SaveRowChanges custom logentry type is activated

Parameters:
phBeforeBuffer	HANDLE
	The handle of the current before buffer (record)

Top

LogInnerJoinEffectiveQuery (integer, character, character, character)

Purpose:	Writes a log line that shows the effective inner-join query
	for a level - the QUERY-PREPARE string with the parent-temp-
	table relation join spliced into the first WHERE clause.
Notes:	SCL-2351. The prepared query itself does not reference the
	parent temp-table buffer (that buffer is not in the dynamic
	data-source's buffer list); the dataset FILL adds the
	equivalent constraint via FILL-WHERE-STRING at FILL time.
	This log message reflects the effective WHERE so the reader
	can verify the parent-child linkage.

Parameters:
piLevel	INTEGER
	The 1-based level being logged
pcTempTableNames	CHARACTER
	Comma-separated temp-table names per level
pcParentTempJoins	CHARACTER
	CHR(1)-delimited source-to-temp-table joins per level
pcQuery	CHARACTER
	The query string prepared on the data-source

Top

LogUnableToFindDbBufferIssue (handle, Error)

Purpose:	Logs details about "Unable to find record for db buffer "name" during
	SAVE-ROW-CHANGES" to the current logfile
Notes:	Invoked by the SaveRowChanges method when error 11912 occurs
	and the SaveRowChanges custom logentry type is activated

Parameters:
phBeforeBuffer	HANDLE
	The handle of the current before buffer (record)
poError	Progress.Lang.Error
	The Error instance

Top

Consultingwerk.OERA.IDSQueryString NewDSQueryString (character, character)

Purpose:	Factory method for the DSQueryString objects
Notes:	It's not recommended that customers override this method, SCL-866
	Customers should rather override the two methods NewDSQueryString
	(pcQuery, pcBuffer, plFilterUsingInnerJoin) and NewDSQueryStringForKeyValueTable
	(pcQuery, pcBuffer, plFilterUsingInnerJoin, poFetchDataByKeyTableParameter,
	pcFieldPairs)

Parameters:
pcQuery	CHARACTER
	The Query String for the DSQueryString instance
pcBuffer	CHARACTER
	The Buffer Name for the DSQueryString instance
Returns	Consultingwerk.OERA.IDSQueryString
	The new IDSQueryString instance

Top

Consultingwerk.OERA.IDSQueryString NewDSQueryString (character, character, logical)

Purpose:	Factory method for the DSQueryString objects
Notes:	Customers should override this method as a factory for custom IDSQueryString
	implementations

Parameters:
pcQuery	CHARACTER
	The Query String for the DSQueryString instance
pcBuffer	CHARACTER
	The Buffer Name for the DSQueryString instance
plFilterUsingInnerJoin	LOGICAL
	Logical value indicating if the data source query should be using an inner join
Returns	Consultingwerk.OERA.IDSQueryString
	The new IDSQueryString instance

Top

Consultingwerk.OERA.IDSQueryString NewDSQueryString (IQueryExpressionWithSort, character, logical)

Purpose:	Factory method for the DSQueryString objects
Notes:	Customers should override this method as a factory for custom IDSQueryString
	implementations

Parameters:
poQuery	Consultingwerk.IQueryExpressionWithSort
	The Query String for the DSQueryString instance
pcBuffer	CHARACTER
	TheIQueryExpressionWithSort instance for the DSQueryString instance
plFilterUsingInnerJoin	LOGICAL
	Logical value indicating if the data source query should be using an inner join
Returns	Consultingwerk.OERA.IDSQueryString
	The new IDSQueryString instance

Top

Consultingwerk.OERA.IDSQueryString NewDSQueryStringForKeyValueTable (character, character, logical, IFetchDataByKeyTableParameter, character)

Purpose:	Factory method for the DSQueryStringForKeyValueTable objects
Notes:	Customers should override this method as a factory for custom
	DSQueryStringForKeyValueTable implementations

Parameters:
pcQuery	CHARACTER
	The Query String for the DSQueryString instance
pcBuffer	CHARACTER
	The Buffer Name for the DSQueryString instance
plFilterUsingInnerJoin	LOGICAL
	Logical value indicating if the data source query should be using an inner join
poFetchDataByKeyTableParameter	Consultingwerk.OERA.IFetchDataByKeyTableParameter
	The IFetchDataByKeyTableParameter instance with the parameter of the FetchDataByKeyTable method
pcFieldPairs	CHARACTER
	The originally attached field pairs
Returns	Consultingwerk.OERA.IDSQueryString
	The new IDSQueryString instance

Top

Consultingwerk.OERA.IDSQueryString NewDSQueryStringForTempTable (character, character, logical, IFetchDataByTempTableParameter)

Purpose:	Factory method for the DSQueryStringForTempTable objects
Notes:	Customers should override this method as a factory for custom
	DSQueryStringForTempTable implementations

Parameters:
pcQuery	CHARACTER
	The Query String for the DSQueryString instance
pcBuffer	CHARACTER
	The Buffer Name for the DSQueryString instance
plFilterUsingInnerJoin	LOGICAL
	Logical value indicating if the data source query should be using an inner join
poFetchDataByTempTableParameter	Consultingwerk.OERA.IFetchDataByTempTableParameter
	The IFetchDataByTempTableParameter instance with the parameter of the FetchDataByTempTable method
Returns	Consultingwerk.OERA.IDSQueryString
	The new IDSQueryString instance

Top

Consultingwerk.IQueryRowIdentifier NewQueryRowIdentifier ()

Purpose:	Overridable factory method to create an instance of the IQueryRowIdentifier
	class
Notes:

Returns	Consultingwerk.IQueryRowIdentifier
	The reference to the new instance of the IQueryRowIdentifier interface

Top

OnAfterSaveChanges (EventArgs)

Purpose:	Raises the AfterSaveChanges
Notes:

Parameters:
e	Consultingwerk.EventArgs
	The Consultingwerk.EventArgs with the data for the event

Top

OnAfterSavingRowChanges (SaveRowChangesEventArgs)

Purpose:	Raises the AfterSavingRowChanges event
Notes:

Parameters:
e	Consultingwerk.OERA.SaveRowChangesEventArgs
	The SaveRowChangesEventArgs with the data for this event

Top

OnBeforeSaveChanges (EventArgs)

Purpose:	Raises the BeforeSaveChanges
Notes:

Parameters:
e	Consultingwerk.EventArgs
	The Consultingwerk.EventArgs with the data for the event

Top

OnBeforeSavingRowChanges (SaveRowChangesEventArgs)

Purpose:	Raises the BeforeSavingRowChanges event
Notes:

Parameters:
e	Consultingwerk.OERA.SaveRowChangesEventArgs
	The SaveRowChangesEventArgs with the data for this event

Top

OnHandleCommitError (HandleCommitErrorEventArgs)

Purpose:	Raises the HandleCommitError
Notes:

Parameters:
e	Consultingwerk.OERA.HandleCommitErrorEventArgs
	The HandleCommitErrorEventArgs with the data for the event

Top

OnHandleCommitSysError (HandleCommitErrorEventArgs)

Purpose:	Raises the HandleCommitSysError
Notes:

Parameters:
e	Consultingwerk.OERA.HandleCommitErrorEventArgs
	The HandleCommitErrorEventArgs with the data for the event

Top

CHARACTER ParentRelationSourceQueryString (handle)

Purpose:	Returns the query string matching the DATA-RELATION field pairs
	referencing the source fields on the parent table
Notes:

Parameters:
phBuffer	HANDLE
	The child buffer of the relation
Returns	CHARACTER
	The source query string matching the data-relation criteria

Top

Consultingwerk.IQueryExpression ParseTopBufferRequestQuery (IFetchDataRequest)

Purpose:	Parses the Query of the top-buffer from the current request
Notes:

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The reference to the IFetchDataRequest
Returns	Consultingwerk.IQueryExpression
	The IQueryExpression representing the query string or ? when there is no query

Top

ProcessFetchDataRequestVariables (IFetchDataRequest)

Purpose:	Expands variables in the FetchDataRequest:Queries
Notes:	Variables are expected within a character value and be surrounded
	by ${ } (ANT style property Syntax)
	${LanguageIsoCode}, ${LanguageKey}, ${UserKey}, ${UserName}, ${UserFullName},
	${CurrentWeek}, ${LastWeek}, ${CurrentMonth}, ${LastMonth}, ${CurrentYear},
	${LastYear}, ${Today}, ${Yesterday}, ${Tomorrow}

Parameters:
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The IFetchDataRequest instance to customize

Top

RepositionBackwards (handle, integer)

Purpose:	Reposition the given query backwards by the given number of records
Notes:	Overridable by child classes to implement custom behavior

Parameters:
phQuery	HANDLE
	The query handle to reposition backwards
piNumRecords	INTEGER
	The number of records

Top

ROWID RepositionBackwards (handle, rowid[], integer)

Purpose:	Evaluates the ROWID from which the ProDataset FILL operation
	needs to start on a backwards fill operation
Notes:	This method may be overridden in a DataAccess object class
	This method is no longer used for the backwards batching.
	It is kept for backwards compatibility of customers code.

Parameters:
phQuery	HANDLE
	The Query Handle to reposition backwards
proRowids	ROWID
	The current ROWID Array
piBatchSize	INTEGER
	The number of records to reposition backwards
Returns	ROWID
	The array of starting ROWIDs for the next FILL operation

Top

SaveBuffer (handle)

Purpose:	Called from saveChanges to process changes
	for a single DataSet temp-table buffer.
Notes:	This is similar to the OERI BE version, but has no pre and
	post transaction hooks because:
	- This method might very well be called inside a transaction.
	- The BE supports hooks outside of the transaction scope.

Parameters:
phBuffer	HANDLE
	The handle of the after buffer

Top

SaveChanges ()

Purpose:	Save changes to physical storage
Notes:	This implementation of data access save traverses all records in order
to:
	- Allow the DA to control transactions, which cannot be directly
	controlled in distributed BL. Transaction control is a concern of
	the BL, but should not be controlled with TRANSACTION keyword.
	- Offer a course grained save interface from distributed BL
	- The default operation here is just a transaction per record
	- This simple sample does not use child relations to traverse
	the buffers as the OERI BE example. (A property that controls
	update order would give the same effect).
	- Traversing of child data from a parent would make sense if done for
	one parent record at a time.

Top

SaveRowChanges (handle)

Purpose:	Overridable method that executes SAVE-ROW-CHANGES on the before buffer
Notes:	Called from CommitChanges

Parameters:
phBeforeBuffer	HANDLE
	The handle of the before buffer

Top

SetDatasetBufferCallback (handle, character, character)

Purpose:	Sets's a ProDataset Buffer Callback-Method (BEFORE-FILL, AFTER-FILL, BEFORE-ROW-FILL, ...)
Notes:

Parameters:
phBuffer	HANDLE
	The ProDataset Buffer Handle to add the callback for
pcCallback	CHARACTER
	The DatasetBufferEventEnum value to add the callback method for
pcMethod	CHARACTER
	The name of the Method to register as a callback

Top

SetDatasetBufferCallback (handle, character, character, Object)

Purpose:	Sets's a ProDataset Buffer Callback-Method (BEFORE-FILL, AFTER-FILL, BEFORE-ROW-FILL, ...)
Notes:

Parameters:
phBuffer	HANDLE
	The ProDataset Buffer Handle to add the callback for
pcCallback	CHARACTER
	The DatasetBufferEventEnum value to add the callback method for
pcMethod	CHARACTER
	The name of the Method to register as a callback
poObject	Progress.Lang.Object
	The Object that contains the callback method

Top

SetDatasetCallback (character, character)

Purpose:	Sets's a ProDataset Callback-Method (BEFORE-FILL, AFTER-FILL)
Notes:

Parameters:
pcCallback	CHARACTER
	The DatasetEventEnum value to add the callback method for
pcMethod	CHARACTER
	The name of the Method to register as a callback

Top

SetDatasetCallback (character, character, Object)

Purpose:	Sets's a ProDataset Callback-Method (BEFORE-FILL, AFTER-FILL)
Notes:

Parameters:
pcCallback	CHARACTER
	The DatasetEventEnum value to add the callback method for
pcMethod	CHARACTER
	The name of the Method to register as a callback
poObject	Progress.Lang.Object
	The Object that contains the callback method

Top

Consultingwerk.IQueryRowIdentifier SkipRecords (integer, handle)

Purpose:	Returns the Query Row Identifier (ROWID) to be used when navigating
	that DATA-SOURCE query based on the Skip argument of the FetchDataRequest
Notes:	Typically used when paging from a JSDO/Kendo UI client, SCL-819, SCL-822

Parameters:
piSkipRecords	INTEGER
	The number of records to skip from the beginning
phBuffer	HANDLE
	The temp-table buffer who's data-source should be navigated using Skip
Returns	Consultingwerk.IQueryRowIdentifier
	The IQueryRowIdentifier identifying the restart rowid

Top

Consultingwerk.IQueryRowIdentifier SkipRecords (integer, handle, logical)

Purpose:	Returns the Query Row Identifier (ROWID) to be used when navigating
	that DATA-SOURCE query based on the Skip argument of the FetchDataRequest
Notes:	Typically used when paging from a JSDO/Kendo UI client, SCL-819, SCL-822

Parameters:
piSkipRecords	INTEGER
	The number of records to skip from the beginning
phBuffer	HANDLE
	The temp-table buffer who's data-source should be navigated using Skip
plSkipRowsSequentially	LOGICAL
	Logical value indicating if we should skip rows sequentially
Returns	Consultingwerk.IQueryRowIdentifier
	The IQueryRowIdentifier identifying the restart rowid

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:
pcTable	CHARACTER
	The temp table name to return the source (database table) field name for
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

Top

CHARACTER SourceColumn2 (character, character)

Purpose:	Wrapper to the SourceColumn method - ensures that Data-Sources are attached
Notes:

Parameters:
pcTable	CHARACTER
	The temp table name to return the source (database table) field name for
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

Top

CHARACTER SourceDefaultQuery (character)

Purpose:	Returns the base query string used to retrieve data for the temp
	tables. This query string will be appended by the query provided by
	the consumer (FetchDataRequest object).
Notes:	Call-back used by Consultingwerk.OERA.Query.DSQueryString (part of
DataAccess:FetchData	FetchData () query preparation
TO-DO:	Provide code to return the DATA-SOURCE root query string

Parameters:
pcTable	CHARACTER
	The temp table name to return the source default (database) query string for
Returns	CHARACTER
	The base query string used to retrieve data for the given temp-table

Top

SplitInnerJoinLevelFragment (character, character, character, character)

Purpose:	Splits the base query string returned by SourceDefaultQuery for
	a single temp-table into the primary source buffer name, the
	primary buffer's WHERE expression (without the leading WHERE
	keyword), and the auxiliary-join remainder.
Notes:	SCL-2351. Used by BuildInnerJoinSourceQuery to compose a single
	inner-join query across multiple temp-tables while still
	respecting the SourceDefaultQuery callback on the DataAccess
	subclass and merging the existing WHERE with the user-provided
	per-level filter using AND.
	The auxiliary-join remainder is delimited by the first top-level
	comma (commas inside parentheses or string literals are skipped).
	The trailing " indexed-reposition" token is stripped if present.
Examples:
	"for each Customer where Customer.CustNum < 500"
	-> pcPrimary = "Customer"
	pcPrimaryWhere = "Customer.CustNum < 500"
	pcAuxJoins = ""
	"for each Order where Order.OrderNum < 10000,
	first b_Customer where b_Customer.CustNum = Order.CustNum"
	-> pcPrimary = "Order"
	pcPrimaryWhere = "Order.OrderNum < 10000"
	pcAuxJoins = ", first b_Customer where b_Customer.CustNum = Order.CustNum"

Parameters:
pcDefaultQuery	CHARACTER
	The query string returned by SourceDefaultQuery for the temp-table
pcPrimary	CHARACTER
	OUTPUT The name of the primary source buffer
pcPrimaryWhere	CHARACTER
	OUTPUT The primary buffer's WHERE expression (without the WHERE keyword); empty when none
pcAuxJoins	CHARACTER
	OUTPUT The remainder of the query from the first top-level comma onwards (including the leading comma); empty when none

Top

CHARACTER StripQueryEnvelope (character)

Purpose:	Strips the leading "for [each] " envelope and trailing
	" indexed-reposition" from a query string.
Notes:	SCL-2351. Helper for SplitInnerJoinLevelFragment.

Parameters:
pcQuery	CHARACTER
	The query string returned by SourceDefaultQuery
Returns	CHARACTER
	The query body without the envelope tokens, trimmed

Top

SuggestDataSourceIndex (handle, character)

Purpose:	Method allows enforcing specific indexes when populating child record
	of a data-relation. When the parent buffer and the child buffer are
	FILL'ed during the ProDataset:FILL() operation, we ensure the given index
Notes:	Allows to avoid situations where in a Order -> OrderLine data-relation
	when filtered by Orderline.ItemNum the itemnum index is chosen instead
	of the more efficient orderline index (both indexes provide one equality
	match, but itemnum is the alphabetically first index)
	This method should be called from the dataset's BEFORE-FILL call back
	Only processes the first buffer of the data-source query, as we assume,
	that the proper join criteria between the data-source query buffers
	is specified in the SourceDefaultQuery

Parameters:
phChildBuffer	HANDLE
	The handle of the child buffer
pcIndexName	CHARACTER
	The index name to use

Top

VerifyRequestTables (character, IFetchDataRequest)

Purpose:	Verifies tables from the current FetchDataRequest
Notes:

Parameters:
pcTables	CHARACTER
	The list of tables form the current request
poFetchDataRequest	Consultingwerk.OERA.IFetchDataRequest
	The reference to the FetchDataRequest instance

Constructor Detail

Top

STATIC DataAccess ()

Purpose:	Static Constructor of the DataAccess class
Notes:

Top

DataAccess (handle)

Purpose:	Constructor of the DataAccess objects
Notes:	Requires to pass a valid dataset handle

Parameters:
phDataset	HANDLE
	The handle of the Business Entity dataset

Event Detail

Top

AfterSaveChanges (Object, EventArgs)

Purpose:	Raised at the end of SaveChanges - within the database transaction
	block
Notes:

Parameters:
sender	Progress.Lang.Object
	The object that raised the AfterSaveChanges event
e	Consultingwerk.EventArgs
	The Consultingwerk.EventArgs with the data for the event

Top

AfterSavingRowChanges (Object, SaveRowChangesEventArgs)

Purpose:	Event raised after the execution of the SAVE-ROW-CHANGES method
	for an individual record in the DataAccessObject
Notes:

Parameters:
sender	Progress.Lang.Object
	The reference to the object that raised this event
e	Consultingwerk.OERA.SaveRowChangesEventArgs
	The SaveRowChangesEventArgs with the data for this event

Top

BeforeSaveChanges (Object, EventArgs)

Purpose:	Raised at the beginning of SaveChanges - within the database transaction
	block
Notes:	This is not a cancelable event - as we have already started the database
	transaction and really only errors should revert it at this point

Parameters:
sender	Progress.Lang.Object
	The object that raised the BeforeSaveChanges event
e	Consultingwerk.EventArgs
	The Consultingwerk.EventArgs with the data for the event

Top

BeforeSavingRowChanges (Object, SaveRowChangesEventArgs)

Purpose:	Event raised before the execution of the SAVE-ROW-CHANGES method
	for an individual record in the DataAccessObject
Notes:

Parameters:
sender	Progress.Lang.Object
	The reference to the object that raised this event
e	Consultingwerk.OERA.SaveRowChangesEventArgs
	The SaveRowChangesEventArgs with the data for this event

Top

HandleCommitError (Object, HandleCommitErrorEventArgs)

Purpose:	Raised to allow custom handling of AppError's (Application errors,
	e.g. from DB triggers) raised while performing the SaveRowChanges method
Notes:

Parameters:
sender	Progress.Lang.Object
	The object that raised the HandleCommitError event
e	Consultingwerk.OERA.HandleCommitErrorEventArgs
	The HandleCommitErrorEventArgs with the data for the event

Top

HandleCommitSysError (Object, HandleCommitErrorEventArgs)

Purpose:	Raised to allow custom handling of SysError's (Progress runtime errors)
	raised while performing the SaveRowChanges method
Notes:

Parameters:
sender	Progress.Lang.Object
	The object that raised the HandleCommitError event
e	Consultingwerk.OERA.HandleCommitErrorEventArgs
	The HandleCommitErrorEventArgs with the data for the event

Property Detail

Top

Consultingwerk.Framework.Collections.CharacterDictionary AssignSkipDictionary

Returns	Consultingwerk.Framework.Collections.CharacterDictionary

Top

CHARACTER AssignSkipList

Returns	CHARACTER

Top

LOGICAL CheckDataTypeConversionForChildRelations

Returns	LOGICAL

Top

CHARACTER CUSTOM_LOG_ENTRY

Returns	CHARACTER

Top

HANDLE DatasetHandle

Returns	HANDLE

Top

LOGICAL DataSourcesAttached

Returns	LOGICAL

Top

CHARACTER DefinedBufferNames

Returns	CHARACTER

Top

CHARACTER FetchDataArgument

Returns	CHARACTER

Top

Progress.Lang.Object FetchDataArguments

Returns	Progress.Lang.Object

Top

Consultingwerk.OERA.IFetchDataRequest FetchDataRequest

Returns	Consultingwerk.OERA.IFetchDataRequest

Top

LOGICAL FilterUsingInnerJoin

Returns	LOGICAL

Top

LOGICAL ForceApplyQueryOnChildTables

Returns	LOGICAL

Top

LOGICAL IgnoreMissingDataSourceOnSaveChanges

Returns	LOGICAL

Top

LOGICAL InFetchDataByKeyTable

Returns	LOGICAL

Top

LOGICAL InFetchDataByTempTable

Returns	LOGICAL

Top

LOGICAL LogFetchDataDetails

Returns	LOGICAL

Top

LOGICAL PrepareJoinedChildTableQueries

Returns	LOGICAL

Top

Consultingwerk.OERA.QueryPurposeEnum QueryPurpose

Returns	Consultingwerk.OERA.QueryPurposeEnum

Top

Consultingwerk.OERA.Enum.RequestTypeEnum RequestType

Returns	Consultingwerk.OERA.Enum.RequestTypeEnum

Top

CHARACTER SourceBufferNames

Returns	CHARACTER

Top

CHARACTER SourceTableNames

Returns	CHARACTER

Top

LOGICAL ThrowErrorsOnFillFailed

Returns	LOGICAL

Top

LOGICAL UseForwardOnlyQueries

Returns	LOGICAL

Top

LOGICAL ValidateRestartRowid

Returns	LOGICAL

info@consultingwerk.de http://www.consultingwerk.de 26.05.2026 16:19:36