Top Method Summary
Options Name Purpose
AttachDataSources () Attaches the DATA-SOURCE objects to the ProDataset Buffers
BindDataset (dataset) Do nothing, just receive the parameter and bind to the received Dataset reference
DefineReadEvents () TO-DO: Subscribe to ProDataset Event Handlers using SET-CALLBACK as needed
DetachDataSources () Detaches the DATA-SOURCE objects to the ProDataset Buffers
eSmartAttachmentAfterRowFill (dataset) Callback method for the AFTER-ROW-FILL event of eSmartAttachment
eSmartAttachmentCreateBeginTrans () Performs validation for new eSmartAttachment rows
FetchData (IFetchDataRequest) Fetch data from the data source
FetchDataByStaticQuery (IFetchDataByStaticQueryRequest) Fetches data for single table, using a static query
FetchSmartAttachmentByAttachmentGUID (character, character) FetchData method for static query
FetchSmartAttachmentByTableGUIDRecordKeyValueAttachmentFolderAttachmentName (character, character, character, character, character) FetchData method for static query
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)
FindSourceBuffer (handle, logical) Locates the matching record in the first source buffer of the given Dataset Buffer
SaveChanges () Save changes to physical storage
SaveRowChanges (handle) Saves the current row
CHARACTER SourceColumn (character, character) Returns the database field name matching a temp-table field name contained in a consumers query string (query string vs. temp-table definition)
CHARACTER 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).

Top Constructor Summary
Options Name Purpose
AttachmentDataAccess (handle) Constructor for the AttachmentDataAccess class


Method Detail
Top

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

BindDataset (dataset)

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

Parameters:
dsAttachment DATASET dsAttachment
DATASET to bind to
Top

DefineReadEvents ()

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

Top

DetachDataSources ()

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

Top

eSmartAttachmentAfterRowFill (dataset)

Purpose: Callback method for the AFTER-ROW-FILL event of eSmartAttachment
Notes: 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:
dsAttachment DATASET dsAttachment
The Dataset
Top

eSmartAttachmentCreateBeginTrans ()

Purpose: Performs validation for new eSmartAttachment rows
Notes:

Top

FetchData (IFetchDataRequest)

Purpose: Fetch data from the data source
Notes: poFetchDataRequest:Context property is used to control batching
(forward/backwards) and the FindRowWhere/PreFetchOnFind
The first entry by CHR(1) in the Context is CHR(2) delimited:
1. Entry: RESTART-ROWID(s) - CHR(5) Delimited
2. Entry: Find String
3. Entry: PrefetchOnFind Value
The poFetchDataRequest parameter may also be passed in as a
FetchDataAccessRequest 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

FetchDataByStaticQuery (IFetchDataByStaticQueryRequest)

Purpose: Fetches data for single table, using a static query
Notes:

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

FetchSmartAttachmentByAttachmentGUID (character, character)

Purpose: FetchData method for static query
Notes:

Parameters:
pcAttachmentGUID CHARACTER
The AttachmentGUID value
pcChildTables CHARACTER
a list of the child tables to fill
Top

FetchSmartAttachmentByTableGUIDRecordKeyValueAttachmentFolderAttachmentName (character, character, character, character, character)

Purpose: FetchData method for static query
Notes:

Parameters:
pcTableGUID CHARACTER
The TableGUID value
pcRecordKeyValue CHARACTER
The RecordKeyValue value
pcAttachmentFolder CHARACTER
The AttachmentFolder value
pcAttachmentName CHARACTER
The AttachmentName value
pcChildTables CHARACTER
a list of the child tables to fill
Top

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

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

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

FindSourceBuffer (handle, logical)

Purpose: Locates the matching record in the first source buffer of the given
Dataset Buffer
Notes: Overrides DataAccess:FindSourceBuffer with conversion of ~ to ~~ (escaping the tilde)

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

SaveChanges ()

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

Top

SaveRowChanges (handle)

Purpose: Saves the current row
Notes: Stores LOB field values, as they are not mapped by the DATA-SOURCE

Parameters:
phBeforeBuffer HANDLE
The handle of the ProDataset before buffer
Top

CHARACTER SourceColumn (character, character)

Purpose: Returns the database field name matching a temp-table field name
contained in a consumers query string (query string vs. temp-table
definition)
Notes: Call-back used by Consultingwerk.OERA.Query.DSQueryString (part of
DataAccess:FetchData FetchData () query preparation

Parameters:
pcTable CHARACTER
The temp table name to return the source (database table) field name for
pcColumn CHARACTER
The temp table column name to return the source (database table) field name for
Returns CHARACTER
The database field name mapped to the passed in temp-table field
Top

CHARACTER SourceDefaultQuery (character)

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

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


Constructor Detail
Top

AttachmentDataAccess (handle)

Purpose: Constructor for the AttachmentDataAccess 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


ProDataset Detail

ProDataset dsAttachment

Member tables: eSmartAttachment


Temp-Table Detail

Temp-Table eSmartAttachment

Defined in:


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