Namespace: Consultingwerk.SmartFramework
Class 
SmartDataAccess Copy to Clipboard
Parent classes:
Inherits: Consultingwerk.OERA.DataAccess
Implements: Consultingwerk.OERA.IDataAccess, Consultingwerk.OERA.IDataAccessCanFind, Consultingwerk.OERA.IDataAccessCountRecords, IDSQueryStringSource, Consultingwerk.OERA.IProvidesSmartRecordInformation
Inherited by: Consultingwerk.SmartFramework.Repository.BusinessEntities.RepositoryObjectDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaDataSource.MetaDataSourceDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaEntityTable.MetaEntityTableDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaBusinessEntity.MetaBusinessEntityDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeGroupDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeUsed.AttributeValueDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeValueDataAccess Consultingwerk.SmartFramework.Repository.Class.ClassTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.LinkTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.ObjectTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.SupportedInstanceObjectTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.SupportedLinkDataAccess Consultingwerk.SmartFramework.Repository.Customization.CustomizationDataAccess Consultingwerk.SmartFramework.Repository.Customization.CustomizationTypeDataAccess Consultingwerk.SmartFramework.Repository.Field.EntityFieldMappingDataAccess Consultingwerk.SmartFramework.Repository.Object.Export.ObjectMasterDataAccess Consultingwerk.SmartFramework.Repository.Object.ObjectMasterDataAccess Consultingwerk.SmartFramework.Repository.Object.WhereUsed.WhereUsedDataAccess Consultingwerk.SmartFramework.Repository.ScreenMapping.EntityTableMappingDataAccess Consultingwerk.SmartFramework.Repository.ScreenMapping.ScreenTypeDataAccess Consultingwerk.SmartFramework.Repository.ScreenMapping.UiTypeDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerJobDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerJobPlanDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerJobStatusDataAccess Consultingwerk.SmartFramework.Authentication.UserDataAccess Consultingwerk.SmartFramework.Authentication.UserProfileDataAccess Consultingwerk.SmartFramework.Authorization.FieldSecurityItemDataAccess Consultingwerk.SmartFramework.Authorization.GroupDataAccess Consultingwerk.SmartFramework.Authorization.MenuGroupDataAccess Consultingwerk.SmartFramework.Authorization.ParentGroupDataAccess Consultingwerk.SmartFramework.Authorization.SecurityAssignmentDataAccess Consultingwerk.SmartFramework.Authorization.SecurityObjectDataAccess Consultingwerk.SmartFramework.Authorization.SecurityRealmDataAccess Consultingwerk.SmartFramework.Authorization.SecurityTokenDataAccess Consultingwerk.SmartFramework.Authorization.ToolbarSecurityItemDataAccess Consultingwerk.SmartFramework.Authorization.UserGroupDataAccess Consultingwerk.SmartFramework.Context.ContextStoreDataAccess Consultingwerk.SmartFramework.Lock.LockDataAccess Consultingwerk.SmartFramework.Menu.MenuDataAccess Consultingwerk.SmartFramework.Menu.MenuStyleDataAccess Consultingwerk.SmartFramework.Menu.ModuleDataAccess Consultingwerk.SmartFramework.Menu.ProductDataAccess Consultingwerk.OERA.DynamicBusinessEntity.DynamicDataAccess Consultingwerk.SmartFramework.System.AttachmentDataAccess Consultingwerk.SmartFramework.System.AttachmentRoleDataAccess Consultingwerk.SmartFramework.System.CommentRoleDataAccess Consultingwerk.SmartFramework.System.ConfigurationValueDataAccess Consultingwerk.SmartFramework.System.DeletionDataAccess Consultingwerk.SmartFramework.System.KeyFieldAssignmentTypeDataAccess Consultingwerk.SmartFramework.System.LanguageDataAccess Consultingwerk.SmartFramework.System.LoginCompanyDataAccess Consultingwerk.SmartFramework.System.MessageDataAccess Consultingwerk.SmartFramework.System.ModifiedStateDataAccess Consultingwerk.SmartFramework.System.RelationDataAccess Consultingwerk.SmartFramework.System.SmartBusinessEntityDataAccess Consultingwerk.SmartFramework.System.TableDataAccess Consultingwerk.SmartFramework.System.TranslationDataAccess Consultingwerk.SmartFramework.System.UiTranslationDataAccess Consultingwerk.SmartFramework.System.ValueListDataAccess Consultingwerk.SmartFramework.Web.RouteDataAccess Consultingwerk.SmartFramework.Workflow.WorkflowDataAccess Consultingwerk.SmartFramework.Workflow.WorkflowInstanceDataAccess Consultingwerk.SmartUnit.OERA.MockDataAccess.GenericMockDataAccess
ABSTRACT

File:SmartDataAccess
Purpose:Enhanced base class for Business Entities that provides
SmartFramework functionality like attachments and comments
Syntax:Abstract base class
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Sun Jan 13 11:12:22 CET 2013
Purpose: The dictionary of SourceTables
Notes: The source tables defines the name of the DB tables which is used
for hooking into the SmartFramework functionality like Attachments
and comments.
By deftault the first DATA-SOURCE table is used. However there may
be cases when this needs to be overridden (e.g. when using another
tables as the first member in a query to optimize read access)
Entries should be in the form of "<databasename.talbename>"



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
Overrides Consultingwerk.OERA.DataAccess:AssignKeyFieldValues (handle)
+ AssignSmartRecordInformation () Assign SmartRecordKey and Attachment/Comment function
# 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
# A AttachDataSources () Attaches the DATA-SOURCE objects to the ProDataset Buffers
Inherited from Consultingwerk.OERA.DataAccess
# 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 procedure is called from SaveChanges in the DA to do the actual database commit and any transaction-related validation logic for a buffer.
Overrides Consultingwerk.OERA.DataAccess:CommitChanges (handle)
+ CountResultRecords (ICountRecordsRequest) Counts the number of result records in the data source query
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
# A DefineReadEvents () TO-DO: Subscribe to ProDataset Event Handlers using SET-CALLBACK as needed
Inherited from Consultingwerk.OERA.DataAccess
# A DetachDataSources () Detaches the DATA-SOURCE objects to the ProDataset Buffers
Inherited from Consultingwerk.OERA.DataAccess
# 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
Inherited from Consultingwerk.OERA.DataAccess
+ FetchDataByKeyTable (IFetchDataByKeyTableParameter) Allows retrieve multiple DB records from a Business Entity based on a temp-table with key values
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
# 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 fiels 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 logile
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 logile
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
+ ResetModifiedState (character, character) Resets a modification for the given table and key field values
# 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
Inherited from Consultingwerk.OERA.DataAccess
# 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
+ 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)
Inherited from Consultingwerk.OERA.DataAccess
+ 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).
Inherited from Consultingwerk.OERA.DataAccess
+ CHARACTER SourceTable (character) Returns the name of the source (database) table for a ProDataset table name
# 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
# CHARACTER TargetColumn (character, character, handle) Returns the temp-table field name matching a database field name
+ TrackModifiedState (character, character) Tracks a modification for the given table and key field values
# VerifyRequestTables (character, IFetchDataRequest) Verifies tables from the current FetchDataRequest
Inherited from Consultingwerk.OERA.DataAccess

Top Constructor Summary
Options Name Purpose
+ SmartDataAccess (handle) Constructor of the SmartDataAccess 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 individul 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 individul 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
+ CHARACTER CUSTOM_LOG_ENTRY
Inherited from Consultingwerk.OERA.DataAccess
+ HANDLE DatasetHandle
Inherited from Consultingwerk.OERA.DataAccess
# LOGICAL DataSourcesAttached
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 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
# Consultingwerk.Framework.Collections.CharacterDictionary SourceTables
# LOGICAL ThrowErrorsOnFillFailed
Inherited from Consultingwerk.OERA.DataAccess
+ LOGICAL TrackDeletions
# LOGICAL UseNoWaitForReferentialIntegrity
# 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)

Overrides Consultingwerk.OERA.DataAccess:AssignKeyFieldValues (handle)
Purpose: Invoked by DataAccess:CommitChanges within the database transaction
to optionally assign key field values for new records
Notes: Assigns key field values for new records based on the
SmartTable.KeyFieldAssignmentGUID setting

Parameters:
phBeforeBuffer HANDLE
The handle of the before buffer
Top

PUBLIC AssignSmartRecordInformation ()

Purpose: Assign SmartRecordKey and Attachment/Comment function
Notes:

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 ()

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

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)

Overrides Consultingwerk.OERA.DataAccess:CommitChanges (handle)
Purpose: This procedure is called from SaveChanges in the DA
to do the actual database commit and any transaction-related
validation logic for a buffer.
Notes: Override to CommitChanges in the DataAccess class. Performs cascading
deletion of SmartAttachment records
Uses Consultingwerk.SmartFramework.IRelationService to ensure
referential integrity (Delete Restrict, Delete Cascade)

Parameters:
phBuffer HANDLE
The handle of the 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 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 ()

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

PROTECTED DetachDataSources ()

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

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)

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

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

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
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
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 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 befure buffer
poSysError Progress.Lang.SysError
The orignal 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 mehod 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 fiels 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 fiels 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 logile
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 logile
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: Overidable by child classes to implement custom behaviour

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 compability 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

PUBLIC ResetModifiedState (character, character)

Purpose: Resets a modification for the given table and key field values
Notes:

Parameters:
pcModifiedTable CHARACTER
The name of the database table to reset the modification for
pcKeyFieldValues CHARACTER
The values of the key fields to reset the modification for
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 ()

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

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
plSkipRowsSequentually 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)

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

PUBLIC CHARACTER SourceDefaultQuery (character)

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

PUBLIC CHARACTER SourceTable (character)

Purpose: Returns the name of the source (database) table for a ProDataset
table name
Notes:

Parameters:
pcTempTableName CHARACTER
The temp-table buffer name to return the source table for
Returns CHARACTER
The database table name of the source 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 choosen 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 CHARACTER TargetColumn (character, character, handle)

Purpose: Returns the temp-table field name matching a database field name
Notes: The database table specified is the source table of the temp-table
This method should be overridden when the default functionality does
not return the proper field mapping (complex joined queries)

Parameters:
pcDatabaseTable CHARACTER
The name of the source database table
pcColumn CHARACTER
The name of the database field to return the mapped temp-table for
phDataSource HANDLE
The data source with the established mapping
Returns CHARACTER
The target (temp-table) field name
Top

PUBLIC TrackModifiedState (character, character)

Purpose: Tracks a modification for the given table and key field values
Notes:

Parameters:
pcModifiedTable CHARACTER
The name of the database table to track the modification for
pcKeyFieldValues CHARACTER
The values of the key fields to track the modification for
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 SmartDataAccess (handle)

Purpose: Constructor of the SmartDataAccess class
Notes:

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 individul 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 individul 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

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 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 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 Consultingwerk.Framework.Collections.CharacterDictionary SourceTables


Returns Consultingwerk.Framework.Collections.CharacterDictionary
Top

PROTECTED LOGICAL ThrowErrorsOnFillFailed

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL
Top

PUBLIC LOGICAL TrackDeletions


Returns LOGICAL
Top

PROTECTED LOGICAL UseNoWaitForReferentialIntegrity


Returns LOGICAL
Top

PROTECTED LOGICAL ValidateRestartRowid

Inherited from Consultingwerk.OERA.DataAccess

Returns LOGICAL


©2006-2020 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       24.05.2022 19:35:40