Namespace: Consultingwerk.BusinessEntityDesigner.Services
Class 
BusinessEntityDataAccess Copy to Clipboard
Parent classes:
Inherits: Consultingwerk.OERA.DataAccess
Implements: Consultingwerk.OERA.IDataAccess, Consultingwerk.OERA.IDataAccessCanFind, Consultingwerk.OERA.IDataAccessCountRecords, IDSQueryStringSource

File:BusinessEntityDataAccess
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Wed Oct 13 19:46:15 CEST 2010

Consultingwerk.BusinessEntityDesigner.Services.BusinessEntityBusinessEntity
Consultingwerk.BusinessEntityDesigner.Services.BusinessEntityBusinessEntity



Top Method Summary
Options Name Purpose
+ ActivateDefaultRelations () Enables the given ProDataset relations. Disables all other parent-relations of the relation's child buffer */
Inherited from Consultingwerk.OERA.DataAccess
+ ActivateRelations (character) Enables the given ProDataset relations. Disables all other parent-relations of the relation's child buffer
Inherited from Consultingwerk.OERA.DataAccess
# AssignKeyFieldValues (handle) Invoked by DataAccess:CommitChanges within the database transaction to optionally assign key field values for new records
Inherited from Consultingwerk.OERA.DataAccess
# LOGICAL AttachDataSource (handle, handle, character) Attaches a data-source object to a temp-table buffer in a ProDataSet object
Inherited from Consultingwerk.OERA.DataAccess
# LOGICAL AttachDataSource (handle, handle, character, character) Attaches a data-source object to a temp-table buffer in a ProDataSet object
Inherited from Consultingwerk.OERA.DataAccess
# LOGICAL AttachDataSource (handle, handle, character, character, character) Attaches a data-source object to a temp-table buffer in a ProDataSet object
Inherited from Consultingwerk.OERA.DataAccess
# LOGICAL AttachDataSource (handle, IBufferDataSource) Attaches a data-source object generated by an BufferDataSource instance to a temp-table buffer in a ProDataSet object
Inherited from Consultingwerk.OERA.DataAccess
# LOGICAL AttachDataSource (handle, IBufferDataSource, character) Attaches a data-source object generated by an BufferDataSource instance to a temp-table buffer in a ProDataSet object
Inherited from Consultingwerk.OERA.DataAccess
# 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
Inherited from Consultingwerk.OERA.DataAccess
# 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
Inherited from Consultingwerk.OERA.DataAccess
# AttachDataSources () Attaches the DATA-SOURCE objects to the ProDataset Buffers
Overrides Consultingwerk.OERA.DataAccess:AttachDataSources ()
- BindDataset (dataset) Do nothing, just receive the parameter and bind to the received Dataset reference
# CHARACTER BuildDataSourceQueryString (handle, IFetchDataRequest, character) Returns the Query String to be used for the DATA-SOURCE of a ProDataset member buffer
Inherited from Consultingwerk.OERA.DataAccess
# CHARACTER BuildDataSourceQueryString (handle, IFetchDataRequest, IQueryExpressionWithSort) Returns the Query String to be used for the DATA-SOURCE of a ProDataset member buffer
Inherited from Consultingwerk.OERA.DataAccess
+ 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.
Inherited from Consultingwerk.OERA.DataAccess
# CheckForRecursiveRelationWithQuery () Checks if the ProDataset contains recursive relations and the top-level-buffer is using a query with the DATA-SOURCE
Inherited from Consultingwerk.OERA.DataAccess
# 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.
Inherited from Consultingwerk.OERA.DataAccess
+ CountResultRecords (ICountRecordsRequest) Counts the number of result records in the data source query
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character, character) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character, character, character) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character, character, character, character, character, character, character, character, character, character) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec, IBufferSpec) Creates a BufferDataSource
Inherited from Consultingwerk.OERA.DataAccess
# CustomizeFetchDataRequest (IFetchDataRequest) Hook method to support customization the IFetchDataRequest or ICountRecordsRequest
Inherited from Consultingwerk.OERA.DataAccess
# LOGICAL DatasetBufferFill (handle, IFetchDataRequest) Invokes the FILL method of a ProDataset member buffer
Inherited from Consultingwerk.OERA.DataAccess
# LOGICAL DatasetFill (handle, IFetchDataRequest) Invokes the ProDataset FILL method
Inherited from Consultingwerk.OERA.DataAccess
# DefineReadEvents () Subscribe to ProDataset Event Handlers using SET-CALLBACK as needed
Overrides Consultingwerk.OERA.DataAccess:DefineReadEvents ()
# DetachDataSources () Detaches the DATA-SOURCE objects to the ProDataset Buffers
Overrides Consultingwerk.OERA.DataAccess:DetachDataSources ()
# EnableDataAccessQueryLogging () Enables DataAccessLogging
Inherited from Consultingwerk.OERA.DataAccess
# CHARACTER ExpandTables (character) Expands the FetchDataRequest:Tables parameter, in case it contains the * wild-card character
Inherited from Consultingwerk.OERA.DataAccess
+ FetchData (IFetchDataRequest) Fetch data from the data source
Overrides Consultingwerk.OERA.DataAccess:FetchData (IFetchDataRequest)
+ FetchDataByKeyTable (IFetchDataByKeyTableParameter) Allows retrieve multiple DB records from a Business Entity based on a temp-table with key values
Inherited from Consultingwerk.OERA.DataAccess
+ FetchDataByStaticQuery (IFetchDataByStaticQueryRequest) Fetches data for single table, using a static query
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataEmptyDataset (IFetchDataRequest) Empties the Dataset before the request
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataFill (IFetchDataRequest, character, handle) Invokes FILL on the Dataset or the given Dataset Buffer
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataFillFindRowWhereBatch (IFetchDataRequest, handle, integer, character[]) Verify that a FindRowWhere on the server does always return a full batch of records
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataFillRepositionTables (IFetchDataRequest, character) FILL's buffers with REPOSITION parent-relations
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataHandleErrorStatus () Handles ERROR-STATUS after the FetchData's FILL
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataLogNextRowid (handle) Logs the NEXT-ROWID and LAST-BATCH property of the fill-buffer
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataLogRestartRowid (handle) Logs the RESTART-ROWID of the fill-buffer
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataPrepareChildTableQuery (IFetchDataRequest, handle, integer, character) Prepares the query for a child table
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataPrepareParentTableQuery (IFetchDataRequest, handle, integer, integer, character, IQueryRowIdentifier, character, FindRecordResult, handle) Prepares the query for a parent table
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataRestoreBatchSizes (integer[]) Restores the Batch-Size of the ProDataset buffers
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataSetBatchContext (handle, character) Updates the batch context with the next-rowids
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataSetFillMode (IFetchDataRequest, handle) Sets the FILL-MODE for a Temp-Table Buffer in preparation for a FILL() method call
Inherited from Consultingwerk.OERA.DataAccess
# FetchDataUpdateRequestContext (IFetchDataRequest, integer, character, IQueryRowIdentifier, character, FindRecordResult) Updates the NextContext, PrevContext and BatchContext properties of the IFetchDataInstance
Inherited from Consultingwerk.OERA.DataAccess
# 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)
Inherited from Consultingwerk.OERA.DataAccess
# 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)
Inherited from Consultingwerk.OERA.DataAccess
+ 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)
Inherited from Consultingwerk.OERA.DataAccess
+ 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)
Inherited from Consultingwerk.OERA.DataAccess
# FindSourceBuffer (handle, logical) Locates the matching record in the first source buffer of the given Dataset Buffer
Inherited from Consultingwerk.OERA.DataAccess
# CHARACTER GetDefinedBufferName (character) Finds a matching buffer name in the current dataset, and returns the defined buffer name
Inherited from Consultingwerk.OERA.DataAccess
# CHARACTER GetDefinedBufferName (integer) Finds a matching buffer name in the current dataset, and returns the defined buffer name
Inherited from Consultingwerk.OERA.DataAccess
# HandleRecordLockedError (handle, SysError) Handles a record locked error invoked during the SAVE-ROW-CHANGES method
Inherited from Consultingwerk.OERA.DataAccess
# InitializeDataAccessQueryLogging () Initializes DataAccessLogging
Inherited from Consultingwerk.OERA.DataAccess
# HANDLE InsertToDataSourceQuery (handle, IFetchDataRequest, character) Creates a new Query to be used as a DATA-SOURCE for a ProDataset member buffer
Inherited from Consultingwerk.OERA.DataAccess
# HANDLE InsertToDataSourceQuery (handle, IFetchDataRequest, IQueryExpressionWithSort) Creates a new Query to be used as a DATA-SOURCE for a ProDataset member buffer
Inherited from Consultingwerk.OERA.DataAccess
# InvokeCommitChangesCallback (CommitCallbackTypeEnum, handle) Invokes a CommitChangesCallback
Inherited from Consultingwerk.OERA.DataAccess
# 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
Inherited from Consultingwerk.OERA.DataAccess
# LogCurrentRowModifiedIssue (handle) Logs details about "current row has been modified by another user to the current logfile
Inherited from Consultingwerk.OERA.DataAccess
# LogUnableToFindDbBufferIssue (handle, Error) Logs details about "Unable to find record for db buffer "name" during SAVE-ROW-CHANGES" to the current logfile
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IDSQueryString NewDSQueryString (character, character) Factory method for the DSQueryString objects
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IDSQueryString NewDSQueryString (character, character, logical) Factory method for the DSQueryString objects
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IDSQueryString NewDSQueryString (IQueryExpressionWithSort, character, logical) Factory method for the DSQueryString objects
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.OERA.IDSQueryString NewDSQueryStringForKeyValueTable (character, character, logical, IFetchDataByKeyTableParameter, character) Factory method for the DSQueryStringForKeyValueTable objects
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.IQueryRowIdentifier NewQueryRowIdentifier () Overridable factory method to create an instance of the IQueryRowIdentifier class
Inherited from Consultingwerk.OERA.DataAccess
# OnAfterSaveChanges (EventArgs) Raises the AfterSaveChanges
Inherited from Consultingwerk.OERA.DataAccess
# OnAfterSavingRowChanges (SaveRowChangesEventArgs) Raises the AfterSavingRowChanges event
Inherited from Consultingwerk.OERA.DataAccess
# OnBeforeSaveChanges (EventArgs) Raises the BeforeSaveChanges
Inherited from Consultingwerk.OERA.DataAccess
# OnBeforeSavingRowChanges (SaveRowChangesEventArgs) Raises the BeforeSavingRowChanges event
Inherited from Consultingwerk.OERA.DataAccess
# OnHandleCommitError (HandleCommitErrorEventArgs) Raises the HandleCommitError
Inherited from Consultingwerk.OERA.DataAccess
# OnHandleCommitSysError (HandleCommitErrorEventArgs) Raises the HandleCommitSysError
Inherited from Consultingwerk.OERA.DataAccess
+ CHARACTER ParentRelationSourceQueryString (handle) Returns the query string matching the DATA-RELATION field pairs referencing the source fields on the parent table
Inherited from Consultingwerk.OERA.DataAccess
# Consultingwerk.IQueryExpression ParseTopBufferRequestQuery (IFetchDataRequest) Parses the Query of the top-buffer from the current request
Inherited from Consultingwerk.OERA.DataAccess
# ProcessFetchDataRequestVariables (IFetchDataRequest) Expands variables in the FetchDataRequest:Queries
Inherited from Consultingwerk.OERA.DataAccess
+ RepositionBackwards (handle, integer) Reposition the given query backwards by the given number of records
Inherited from Consultingwerk.OERA.DataAccess
# ROWID RepositionBackwards (handle, rowid[], integer) Evaluates the ROWID from which the ProDataset FILL operation needs to start on a backwards fill operation
Inherited from Consultingwerk.OERA.DataAccess
# SaveBuffer (handle) Called from saveChanges to process changes for a single DataSet temp-table buffer.
Inherited from Consultingwerk.OERA.DataAccess
+ SaveChanges () Save changes to physical storage
Overrides Consultingwerk.OERA.DataAccess:SaveChanges ()
# SaveRowChanges (handle) Overridable method that executes SAVE-ROW-CHANGES on the before buffer
Inherited from Consultingwerk.OERA.DataAccess
# SetDatasetBufferCallback (handle, character, character) Sets's a ProDataset Buffer Callback-Method (BEFORE-FILL, AFTER-FILL, BEFORE-ROW-FILL, ...)
Inherited from Consultingwerk.OERA.DataAccess
# SetDatasetBufferCallback (handle, character, character, Object) Sets's a ProDataset Buffer Callback-Method (BEFORE-FILL, AFTER-FILL, BEFORE-ROW-FILL, ...)
Inherited from Consultingwerk.OERA.DataAccess
# SetDatasetCallback (character, character) Sets's a ProDataset Callback-Method (BEFORE-FILL, AFTER-FILL)
Inherited from Consultingwerk.OERA.DataAccess
# SetDatasetCallback (character, character, Object) Sets's a ProDataset Callback-Method (BEFORE-FILL, AFTER-FILL)
Inherited from Consultingwerk.OERA.DataAccess
# 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
Inherited from Consultingwerk.OERA.DataAccess
# 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
Inherited from Consultingwerk.OERA.DataAccess
+ 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)
Overrides Consultingwerk.OERA.DataAccess:SourceColumn (character, character)
+ CHARACTER SourceColumn2 (character, character) Wrapper to the SourceColumn method - ensures that Data-Sources are attached
Inherited from Consultingwerk.OERA.DataAccess
+ 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).
Overrides Consultingwerk.OERA.DataAccess:SourceDefaultQuery (character)
# 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
Inherited from Consultingwerk.OERA.DataAccess
# VerifyRequestTables (character, IFetchDataRequest) Verifies tables from the current FetchDataRequest
Inherited from Consultingwerk.OERA.DataAccess

Top Constructor Summary
Options Name Purpose
+ BusinessEntityDataAccess (handle) Constructor for the &1 class

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

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


Method Detail
Top

PUBLIC ActivateDefaultRelations ()

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Enables the given ProDataset relations. Disables all other
parent-relations of the relation's child buffer

Top

PUBLIC ActivateRelations (character)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED AssignKeyFieldValues (handle)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED LOGICAL AttachDataSource (handle, handle, character)

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED LOGICAL AttachDataSource (handle, IBufferDataSource)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED LOGICAL AttachDataSource (handle, IBufferDataSource, character)

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED AttachDataSources ()

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

Top

PRIVATE BindDataset (dataset)

Purpose: Do nothing, just receive the parameter and bind to the received
Dataset reference
Notes:

Parameters:
dsBusinessEntity DATASET dsBusinessEntity
DATASET to bind to
Top

PROTECTED CHARACTER BuildDataSourceQueryString (handle, IFetchDataRequest, character)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED CHARACTER BuildDataSourceQueryString (handle, IFetchDataRequest, IQueryExpressionWithSort)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC CanFind (CanFindParameter)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED CheckForRecursiveRelationWithQuery ()

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED CommitChanges (handle)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC CountResultRecords (ICountRecordsRequest)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (character)

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED Consultingwerk.OERA.IBufferDataSource CreateBufferDataSource (IBufferSpec)

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Creates a BufferDataSource
Notes:

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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED CustomizeFetchDataRequest (IFetchDataRequest)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED LOGICAL DatasetBufferFill (handle, IFetchDataRequest)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED LOGICAL DatasetFill (handle, IFetchDataRequest)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED DefineReadEvents ()

Overrides Consultingwerk.OERA.DataAccess:DefineReadEvents ()
Purpose: Subscribe to ProDataset Event Handlers using SET-CALLBACK
as needed
Notes: Not used in this class

Top

PROTECTED DetachDataSources ()

Overrides Consultingwerk.OERA.DataAccess:DetachDataSources ()
Purpose: Detaches the DATA-SOURCE objects to the ProDataset Buffers
Notes: Not used in this class

Top

PROTECTED EnableDataAccessQueryLogging ()

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Enables DataAccessLogging
Notes:

Top

PROTECTED CHARACTER ExpandTables (character)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC FetchData (IFetchDataRequest)

Overrides Consultingwerk.OERA.DataAccess:FetchData (IFetchDataRequest)
Purpose: Fetch data from the data source
Notes: When the Context property of the IFetchDataRequest object is "<NEW>" then a new business entity will be initialized

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

PUBLIC FetchDataByKeyTable (IFetchDataByKeyTableParameter)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC FetchDataByStaticQuery (IFetchDataByStaticQueryRequest)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED FetchDataEmptyDataset (IFetchDataRequest)

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Empties the Dataset before the request
Notes: Optionally support for IFetchDataAccessRequest:AppendFetchData (SCL-1048)

Parameters:
poFetchDataRequest Consultingwerk.OERA.IFetchDataRequest
The IFetchDataRequest instance
Top

PROTECTED FetchDataFill (IFetchDataRequest, character, handle)

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED FetchDataFillRepositionTables (IFetchDataRequest, character)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED FetchDataHandleErrorStatus ()

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Handles ERROR-STATUS after the FetchData's FILL
Notes:

Top

PROTECTED FetchDataLogNextRowid (handle)

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Logs the NEXT-ROWID and LAST-BATCH property of the fill-buffer
Notes:

Parameters:
phFillBuffer HANDLE
The handle of the fill-buffer
Top

PROTECTED FetchDataLogRestartRowid (handle)

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Logs the RESTART-ROWID of the fill-buffer
Notes:

Parameters:
phFillBuffer HANDLE
The handle of the fill-buffer
Top

PROTECTED FetchDataPrepareChildTableQuery (IFetchDataRequest, handle, integer, character)

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED FetchDataRestoreBatchSizes (integer[])

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Restores the Batch-Size of the ProDataset buffers
Notes:

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

PROTECTED FetchDataSetBatchContext (handle, character)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED FetchDataSetFillMode (IFetchDataRequest, handle)

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED FindSourceBuffer (handle, logical)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED CHARACTER GetDefinedBufferName (character)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED CHARACTER GetDefinedBufferName (integer)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED HandleRecordLockedError (handle, SysError)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED InitializeDataAccessQueryLogging ()

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Initializes DataAccessLogging
Notes:

Top

PROTECTED HANDLE InsertToDataSourceQuery (handle, IFetchDataRequest, character)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED HANDLE InsertToDataSourceQuery (handle, IFetchDataRequest, IQueryExpressionWithSort)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED InvokeCommitChangesCallback (CommitCallbackTypeEnum, handle)

Inherited from Consultingwerk.OERA.DataAccess
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 CommitCallbackTypeEnum
The CommitCallbackTypeEnum value describing the callback to be invoked
phBeforeBuffer HANDLE
The handle of the before-buffer (to determine the ROW-STATE)
Top

PROTECTED LOGICAL IsQueryFlagPresent (character, character)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED LogCurrentRowModifiedIssue (handle)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED LogUnableToFindDbBufferIssue (handle, Error)

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

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

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED Consultingwerk.IQueryRowIdentifier NewQueryRowIdentifier ()

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED OnAfterSaveChanges (EventArgs)

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Raises the AfterSaveChanges
Notes:

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

PROTECTED OnAfterSavingRowChanges (SaveRowChangesEventArgs)

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Raises the AfterSavingRowChanges event
Notes:

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

PROTECTED OnBeforeSaveChanges (EventArgs)

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Raises the BeforeSaveChanges
Notes:

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

PROTECTED OnBeforeSavingRowChanges (SaveRowChangesEventArgs)

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Raises the BeforeSavingRowChanges event
Notes:

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

PROTECTED OnHandleCommitError (HandleCommitErrorEventArgs)

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Raises the HandleCommitError
Notes:

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

PROTECTED OnHandleCommitSysError (HandleCommitErrorEventArgs)

Inherited from Consultingwerk.OERA.DataAccess
Purpose: Raises the HandleCommitSysError
Notes:

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

PUBLIC CHARACTER ParentRelationSourceQueryString (handle)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED Consultingwerk.IQueryExpression ParseTopBufferRequestQuery (IFetchDataRequest)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED ProcessFetchDataRequestVariables (IFetchDataRequest)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC RepositionBackwards (handle, integer)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED ROWID RepositionBackwards (handle, rowid[], integer)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED SaveBuffer (handle)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC SaveChanges ()

Overrides Consultingwerk.OERA.DataAccess:SaveChanges ()
Purpose: Save changes to physical storage
Notes: Override to DataAccess base class

Top

PROTECTED SaveRowChanges (handle)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED SetDatasetBufferCallback (handle, character, character)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED SetDatasetBufferCallback (handle, character, character, Object)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED SetDatasetCallback (character, character)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED SetDatasetCallback (character, character, Object)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED Consultingwerk.IQueryRowIdentifier SkipRecords (integer, handle)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED Consultingwerk.IQueryRowIdentifier SkipRecords (integer, handle, logical)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC CHARACTER SourceColumn (character, character)

Overrides Consultingwerk.OERA.DataAccess: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

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

PUBLIC CHARACTER SourceColumn2 (character, character)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC CHARACTER SourceDefaultQuery (character)

Overrides Consultingwerk.OERA.DataAccess: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

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

PROTECTED SuggestDataSourceIndex (handle, character)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED VerifyRequestTables (character, IFetchDataRequest)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC BusinessEntityDataAccess (handle)

Purpose: Constructor for the &1 class
Notes: Used by the BusinessEntity, will receive the handle of the dataset
instance form the BusinessEntity as a parameter. Permanently BIND's
to that dataset using the PRIVATE BindDataset Method.

Parameters:
phDataset HANDLE
The handle of the Business Entity dataset


Event Detail
Top

PUBLIC AfterSaveChanges (Object, EventArgs)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC AfterSavingRowChanges (Object, SaveRowChangesEventArgs)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC BeforeSaveChanges (Object, EventArgs)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC BeforeSavingRowChanges (Object, SaveRowChangesEventArgs)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC HandleCommitError (Object, HandleCommitErrorEventArgs)

Inherited from Consultingwerk.OERA.DataAccess
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

PUBLIC HandleCommitSysError (Object, HandleCommitErrorEventArgs)

Inherited from Consultingwerk.OERA.DataAccess
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

PROTECTED Consultingwerk.Framework.Collections.CharacterDictionary AssignSkipDictionary

Inherited from Consultingwerk.OERA.DataAccess

Returns Consultingwerk.Framework.Collections.CharacterDictionary
Top

PUBLIC CHARACTER AssignSkipList

Inherited from Consultingwerk.OERA.DataAccess

Returns CHARACTER
Top

PROTECTED LOGICAL CheckDataTypeConversionForChildRelations

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PUBLIC CHARACTER CUSTOM_LOG_ENTRY

Inherited from Consultingwerk.OERA.DataAccess

Returns CHARACTER
Top

PUBLIC HANDLE DatasetHandle

Inherited from Consultingwerk.OERA.DataAccess

Returns HANDLE
Top

PROTECTED LOGICAL DataSourcesAttached

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PROTECTED CHARACTER DefinedBufferNames

Inherited from Consultingwerk.OERA.DataAccess

Returns CHARACTER
Top

PROTECTED CHARACTER FetchDataArgument

Inherited from Consultingwerk.OERA.DataAccess

Returns CHARACTER
Top

PROTECTED Progress.Lang.Object FetchDataArguments

Inherited from Consultingwerk.OERA.DataAccess

Returns Progress.Lang.Object
Top

PROTECTED Consultingwerk.OERA.IFetchDataRequest FetchDataRequest

Inherited from Consultingwerk.OERA.DataAccess

Returns Consultingwerk.OERA.IFetchDataRequest
Top

PUBLIC LOGICAL FilterUsingInnerJoin

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PUBLIC LOGICAL ForceApplyQueryOnChildTables

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PROTECTED LOGICAL IgnoreMissingDataSourceOnSaveChanges

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PROTECTED LOGICAL InFetchDataByKeyTable

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PUBLIC LOGICAL LogFetchDataDetails

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PROTECTED LOGICAL PrepareJoinedChildTableQueries

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PROTECTED Consultingwerk.OERA.QueryPurposeEnum QueryPurpose

Inherited from Consultingwerk.OERA.DataAccess

Returns Consultingwerk.OERA.QueryPurposeEnum
Top

PUBLIC RequestTypeEnum RequestType

Inherited from Consultingwerk.OERA.DataAccess

Returns RequestTypeEnum
Top

PROTECTED CHARACTER SourceBufferNames

Inherited from Consultingwerk.OERA.DataAccess

Returns CHARACTER
Top

PROTECTED CHARACTER SourceTableNames

Inherited from Consultingwerk.OERA.DataAccess

Returns CHARACTER
Top

PROTECTED LOGICAL ThrowErrorsOnFillFailed

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PROTECTED LOGICAL UseForwardOnlyQueries

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PROTECTED LOGICAL ValidateRestartRowid

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL


ProDataset Detail

ProDataset dsBusinessEntity

Member tables: eBusinessEntity, eDataRelation, eDataRelationProperties, eTable, eField, eFieldProperties, eIndex, eIndexProperties, eTableProperties, eBusinessEntityProperties


Temp-Table Detail

Temp-Table eBusinessEntity

Defined in:

Temp-Table eBusinessEntityProperties

Defined in:

Temp-Table eDataRelation

Defined in:

Temp-Table eDataRelationProperties

Defined in:

Temp-Table eField

Defined in:

Temp-Table eFieldProperties

Defined in:

Temp-Table eIndex

Defined in:

Temp-Table eIndexProperties

Defined in:

Temp-Table eTable

Defined in:

Temp-Table eTableProperties

Defined in:


©2006-2023 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       08.12.2024 12:57:08