Namespace: Consultingwerk.Util
Class 
DatasetHelper Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.Util.DatasetHelper

Inherits: Progress.Lang.Object


Navigate to: Methods | Constructors | Events | Properties | ProDatasets | Temp-Tables



Top Method Summary
Options Name Purpose
ActivateRelations (handle, character) Enables the given ProDataset relations. Disables all other parent-relations of the relation's child buffer
CHARACTER ActiveRelationNames (handle) Returns a comma-delimited list of the names of the enabled relations in the ProDataset
AddErrorString (handle, character) Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR attribute of the BUFFER and the ProDataset
AddErrorString (handle, character, character) Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR attribute of the BUFFER and the ProDataset
AddErrorString (handle, character, character, character) Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR attribute of the BUFFER and the ProDataset
AddErrorString (handle, ListNameValuePair) Adds ERROR-STRINGs to a ProDataset Buffer, and sets the ERROR attribute of the BUFFER and the ProDataset
AddErrorString (handle, ListNameValuePair, character) Adds ERROR-STRINGs to a ProDataset Buffer, and sets the ERROR attribute of the BUFFER and the ProDataset
AddErrorString (IBufferHandle, character) Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR attribute of the BUFFER and the ProDataset
AddErrorString (IBufferHandle, character, character) Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR attribute of the BUFFER and the ProDataset
AddErrorString (IBufferHandle, character, character, character) Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR attribute of the BUFFER and the ProDataset
AddErrorString (IBufferHandle, ListNameValuePair) Adds ERROR-STRINGs to a ProDataset Buffer, and sets the ERROR attribute of the BUFFER and the ProDataset
AddErrorString (IBufferHandle, ListNameValuePair, character) Adds ERROR-STRINGs to a ProDataset Buffer, and sets the ERROR attribute of the BUFFER and the ProDataset
CHARACTER AllChildBufferNames (handle) Returns a comma-delimited list of the names of the child buffers of a ProDataset buffer
CHARACTER AllChildBuffers (handle) Returns a comma-delimited list of the handles of the child buffers of a ProDataset buffer
CHARACTER BufferNames (handle) Returns a list of all buffer names in the ProDataset
CHARACTER BufferNamesFromSerializeName (character, handle) Converts a list of SERIALIZE-NAME's of ProDataset temp-tables to buffer names
CHARACTER ChildBufferNames (handle) Returns a comma-delimited list of the names of the child buffers of a ProDataset buffer
CHARACTER ChildBuffers (handle) Returns a comma-delimited list of the handles of the child buffers of a ProDataset buffer
CHARACTER ChildRelationQueryString (handle) Returns the query string matching a DATA-RELATION field pairs
CHARACTER ChildRelationQueryStringWithValues (handle) Returns the query string matching a DATA-RELATION field pairs
LOGICAL ChildRelationUnique (handle) Returns if the child buffer relation is unique
HANDLE CloneDatasetWithoutSerializeHidden (handle) Clones the dataset without serialize hidden fields
LOGICAL CopyErrorStatus (handle, handle) Copies the error-status from the source dataset to the target dataset
CopyReadOnlyTables (handle, handle) Copies the read-only tables (no before table) from the source dataset to the target dataset
CopyUnmodifiedRecords (handle, handle) Copies unmodified records from the source into the target dataset
Consultingwerk.Util.Enum.DatasetControlStringEnum DatasetControlString (handle) Returns _CANCEL or _QUESTIONS-PENDING when contained in the ERROR-STRING of at least a single record
Consultingwerk.RecordIdentifier DatasetErrorRecordIdentifier (handle) Returns the RecordIdentifier identifying the first record in the ProDataset with Errors
CHARACTER DatasetErrorStrings (handle) Returns a single CHARACTER string composed of the error-strings of all records (from all tables in the given Dataset instance)
LONGCHAR DatasetErrorStringsLong (handle) Returns a single CHARACTER string composed of the error-strings of all records (from all tables in the given Dataset instance)
HANDLE DatasetFieldHandle (handle, character, character, character) Returns the buffer-field handle for the given lookup field
ROWID DatasetQueryRowids (handle, handle, rowid[]) Extracts the Rowids from an array of ROWID's in order of Buffer-Sequence in a ProDataset to an array of those ROWID's used in a query on buffers of the ProDataset
DeleteCascade (handle) Deletes the record from the given ProDataset buffer and recursively deletes all child records
DeleteCascade (handle, logical, character) Deletes the record from the given ProDataset buffer and recursively deletes all child records
DeleteDatasetAndBuffers (handle) Deletes a ProDataset object handle and all it's buffers
DeleteDatasetAndTempTables (handle) Deletes a ProDataset object handle and all it's member temp-table
DeleteOrphanedRecords (handle) Deletes orphaned records in the given Dataset or child table
DeleteOrphanedRecords (handle, logical) Deletes orphaned records in the given Dataset or child table
DeleteRestrict (handle) Deletes the record from the given ProDataset buffer only when there is no child record
DetachDataSources (handle) Detaches the DATA-SOURCE's of the ProDataset buffer
EmptyDataset (handle) Empties a ProDataset
HANDLE FindBufferWithField (handle, character, character) Find the first buffer of the list in the given ProDataset that contains a field with the given name
HANDLE GetBufferHandle (handle, character) Returns the handle of a ProDataset buffer by the name
HANDLE GetBufferHandles (handle) Returns an Array of the Buffer handles of the given Dataset
INTEGER GetBufferIndex (handle, character) Returns the index of the buffer name in the ProDataset
HANDLE GetChangesDataset (handle) Builds a dataset containing the changes records from the source dataset.
HANDLE GetChildRelation (handle, character) Returns the handle of the child relation of a buffer by name
ROWID GetDatasetRowids (handle) Returns an array with the current ROWID's of every ProDataset buffer
HANDLE GetDatasetWithCurrentRecord (handle) Creates a Dataset as a copy of another Dataset that only contains the current record in the given ProDataset temp-table buffer
HANDLE GetDatasetWithoutRelations (handle) Returns a Dataset with the same schema but no relations
HANDLE GetDataSourceQueryHandles (handle) Returns an array of the Query handles of the Data-Sources of the given Dataset
CHARACTER GetFillWhereStrings (handle) Returns an array of the FILL-WHERE-STRING's of the Data-Sources of the given Dataset
HANDLE GetTableHandles (handle) Returns an Array of the Temp-Table handles of the given Dataset
LOGICAL GetTrackingChanges (handle) Returns if the Dataset is currently TRACKING-CHANGES
LOGICAL HasBuffer (handle, character) Returns if the the passed in ProDataset handle has a buffer with the given name
LOGICAL HasChanges (handle) Tests if a ProDataset has changes
LOGICAL HasCreatedRecords (handle) Returns if the Dataset has records with a ROW-STATE of ROW-CREATED
LOGICAL HasDeletedRecords (handle) Returns if the Dataset has records with a ROW-STATE of ROW-DELETED
LOGICAL HasErrors (handle) Returns if the Dataset contains a record with an ERROR-STRING, ERROR or REJECTED
LOGICAL HasModifiedRecords (handle) Returns if the Dataset has records with a ROW-STATE of ROW-MODIFIED
LOGICAL HasRecursiveRelationFromTopLevelBuffer (handle) Checks if the ProDataset contains an active recursive data-relation from any of the top-level buffers
LOGICAL HasRowState (handle, integer) Returns if the Dataset has records with a given ROW-STATE
LOGICAL HasSerializeHiddenColumns (handle) Returns if the Dataset contains serialize-hidden columns
LOGICAL HasValidationMessages (handle) Returns if the ProDataset or ProDataset Buffer has any validation messages (BUFFER ERROR-STRING)
LOGICAL HasValidationMessages (handle, character) Returns if the ProDataset or ProDataset Buffer has any validation messages (BUFFER ERROR-STRING) for the given field name
LOGICAL HasValidationMessages (handle, character, character) Returns if the ProDataset or ProDataset Buffer has any validation messages (BUFFER ERROR-STRING) for the given field name and the given message group and number
LOGICAL HasValidationMessages (handle, character, character, integer) Returns if the ProDataset or ProDataset Buffer has any validation messages (BUFFER ERROR-STRING) for the given field name and the given message group and number
LOGICAL HasValidationMessages (handle, character, character, integer, character, character, character, character, character, character, character, character, character) Returns if the ProDataset or ProDataset Buffer has any validation messages (BUFFER ERROR-STRING) for the given field name and the given message group and number
LOGICAL HasValidationMessages (handle, character, integer) Returns if the ProDataset or ProDataset Buffer has any validation messages (BUFFER ERROR-STRING) of the given message group and number
LOGICAL HasValidationMessages (handle, character, integer, character, character, character, character, character, character, character, character, character) Returns if the ProDataset or ProDataset Buffer has any validation messages (BUFFER ERROR-STRING) of the given message group and number with the provided substitution values
LOGICAL IsUniqueChildRelation (handle) Returns if the provided data-relation is pointing to an unique child record
MergeUnmodifiedRecords (handle, handle) Merges the records of the source dataset into the target dataset. Does not overwrite modified records of the target dataset
HANDLE ParentBuffer (handle) Returns the handle of the parent buffer of a ProDataset buffer
Consultingwerk.Framework.Collections.RowidDictionary ParentRecordRowids (handle) Returns a RowidDictionary with the ROWID's of the current record as well as the parent and grand-parent ... records based on the ProDataset relations
CHARACTER ParentRelationWhereStringWithTypeConversion (handle) Returns the where string matching a DATA-RELATION and inserts functions for data type conversion if required
CHARACTER ParentRelationWhereStringWithValues (handle) Returns the where string matching a DATA-RELATION field pairs
ReadXml (handle, character) Loads the given Dataset from an XML file using EMPTY mode: clears all existing rows and then populates the dataset from the xml file.
RejectNonCreateChanges (handle) Rejects all row-changes in the ProDatasets before tables that do not have the row-mod of Adding
RepositionDatasetBuffers (handle, rowid[]) Locates the records in all ProDataset buffers based on an Array of ROWID's
ResolveSmartErrorMessages (handle) Resolves SmartMessages in the Dataset records ERROR-STRING
SanitizeErrors (handle) Sanitizes ProDataset ERROR-STRING and ERROR
SetControlCancel (handle) Sets the ERROR-STRING of a ProDataset Buffer, and the ERROR attribute of the BUFFER and the ProDataset based on a DatasetControlStringEnum value
SetControlString (handle, DatasetControlStringEnum) Sets the ERROR-STRING of a ProDataset Buffer, and the ERROR attribute of the BUFFER and the ProDataset based on a DatasetControlStringEnum value
SetDataSourceQueryHandles (handle, handle[]) Assigns the Query handles of the data-source widgets attached to the ProDataset buffers
SetErrorString (handle, character) Sets the ERROR-STRING of a ProDataset Buffer, and the ERROR attribute of the BUFFER and the ProDataset
SetFillWhereStrings (handle, character[]) Assigns the FILL-WHERE-STRING's of the data-source widgets attached to the ProDataset buffers
SetSerializeNameFromXmlNodeName (handle) Sets all of a dataset's SERIALIZE-NAME attributes the value of the XML-NODE-NAME attribute. If a SERIALIZE-NAME value is the same as the NAME value, and the XML-NODE-NAME value is different, then the SERIALIZE-NAME value will be set to the XML-NODE-NAME.
SetTrackingChanges (handle, logical) Sets the tracking changes property of all temp-tables of the passed in dataset
SetTrackingChanges (handle, logical, DynamicTempTablesEnum) Sets the tracking changes property of all temp-tables of the passed in dataset
CHARACTER SiblingWhereStringWithValues (handle) Returns the where string matching a DATA-RELATION field pairs for a child buffer of the FOR EACH for a parent buffer
ThrowDatasetErrors (handle) Throws Dataset Validation error messages from the ERROR-STRING attributes of any record

Top Constructor Summary
Options Name Purpose
DatasetHelper () Protected default constructor.


Method Detail
Top

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

Parameters:
phDataset HANDLE
The handle of the ProDataset
pcRelationNames CHARACTER
The name of the relation to enable
Top

CHARACTER ActiveRelationNames (handle)
Purpose: Returns a comma-delimited list of the names of the enabled relations in the
ProDataset
Notes:

Parameters:
phDataset HANDLE
The handle of the ProDataset
Returns CHARACTER
The comma-delimited list of the names of the enabled relations
Top

AddErrorString (handle, character)
Purpose: Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR
attribute of the BUFFER and the ProDataset
Notes:

Parameters:
phBuffer HANDLE
The ProDataset Member Buffer
pcErrorString CHARACTER
The Error-String to add
Top

AddErrorString (handle, character, character)
Purpose: Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR
attribute of the BUFFER and the ProDataset
Notes:

Parameters:
phBuffer HANDLE
The ProDataset Member Buffer
pcErrorString CHARACTER
The Error-String to add
pcErrorFieldName CHARACTER
The name of the field this error message belongs to
Top

AddErrorString (handle, character, character, character)
Purpose: Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR
attribute of the BUFFER and the ProDataset
Notes:

Parameters:
phBuffer HANDLE
The ProDataset Member Buffer
pcErrorString CHARACTER
The Error-String to add
pcErrorFieldName CHARACTER
The name of the field this error message belongs to
pcErrorBufferName CHARACTER
The name of the buffer this error message belongs to
Top

AddErrorString (handle, ListNameValuePair)
Purpose: Adds ERROR-STRINGs to a ProDataset Buffer, and sets the ERROR
attribute of the BUFFER and the ProDataset
Notes:

Parameters:
phBuffer HANDLE
The ProDataset Member Buffer
poMessages Consultingwerk.ListNameValuePair
The List of Field/Message pairs to add messages for
Top

AddErrorString (handle, ListNameValuePair, character)
Purpose: Adds ERROR-STRINGs to a ProDataset Buffer, and sets the ERROR
attribute of the BUFFER and the ProDataset
Notes:

Parameters:
phBuffer HANDLE
The ProDataset Member Buffer
poMessages Consultingwerk.ListNameValuePair
The List of Field/Message pairs to add messages for
pcErrorBufferName CHARACTER
The name of the buffer this error message belongs to
Top

AddErrorString (IBufferHandle, character)
Purpose: Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR
attribute of the BUFFER and the ProDataset
Notes:

Parameters:
poBufferHandle Consultingwerk.OERA.IBufferHandle
The Reference to the IBufferHandle or TableModel instance
pcErrorString CHARACTER
The Error-String to add
Top

AddErrorString (IBufferHandle, character, character)
Purpose: Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR
attribute of the BUFFER and the ProDataset
Notes:

Parameters:
poBufferHandle Consultingwerk.OERA.IBufferHandle
The Reference to the IBufferHandle or TableModel instance
pcErrorString CHARACTER
The Error-String to add
pcErrorFieldName CHARACTER
The name of the field this error message belongs to
Top

AddErrorString (IBufferHandle, character, character, character)
Purpose: Adds an ERROR-STRING to a ProDataset Buffer, and sets the ERROR
attribute of the BUFFER and the ProDataset
Notes:

Parameters:
poBufferHandle Consultingwerk.OERA.IBufferHandle
The Reference to the IBufferHandle or TableModel instance
pcErrorString CHARACTER
The Error-String to add
pcErrorFieldName CHARACTER
The name of the field this error message belongs to
pcErrorBufferName CHARACTER
The name of the buffer this error message belongs to
Top

AddErrorString (IBufferHandle, ListNameValuePair)
Purpose: Adds ERROR-STRINGs to a ProDataset Buffer, and sets the ERROR
attribute of the BUFFER and the ProDataset
Notes:

Parameters:
poBufferHandle Consultingwerk.OERA.IBufferHandle
The Reference to the IBufferHandle or TableModel instance
poMessages Consultingwerk.ListNameValuePair
The List of Field/Message pairs to add messages for
Top

AddErrorString (IBufferHandle, ListNameValuePair, character)
Purpose: Adds ERROR-STRINGs to a ProDataset Buffer, and sets the ERROR
attribute of the BUFFER and the ProDataset
Notes:

Parameters:
poBufferHandle Consultingwerk.OERA.IBufferHandle
The Reference to the IBufferHandle or TableModel instance
poMessages Consultingwerk.ListNameValuePair
The List of Field/Message pairs to add messages for
pcErrorBufferName CHARACTER
The name of the buffer this error message belongs to
Top

CHARACTER AllChildBufferNames (handle)
Purpose: Returns a comma-delimited list of the names of the child buffers
of a ProDataset buffer
Notes: Recursively returns also grand-children

Parameters:
phBuffer HANDLE
The ProDataset buffer handle to return child buffers from
Returns CHARACTER
The comma-delimited list of the handles of the child buffers
Top

CHARACTER AllChildBuffers (handle)
Purpose: Returns a comma-delimited list of the handles of the child buffers
of a ProDataset buffer
Notes: Recursively returns also grand-children

Parameters:
phBuffer HANDLE
The ProDataset buffer handle to return child buffers from
Returns CHARACTER
The comma-delimited list of the handles of the child buffers
Top

CHARACTER BufferNames (handle)
Purpose: Returns a list of all buffer names in the ProDataset
Notes:

Parameters:
phDataset HANDLE
The handle of the ProDataset
Returns CHARACTER
The comma-delimited list of buffer names
Top

CHARACTER BufferNamesFromSerializeName (character, handle)
Purpose: Converts a list of SERIALIZE-NAME's of ProDataset temp-tables
to buffer names
Notes:

Parameters:
pcSerializeNames CHARACTER
The comma delimited list of SERIALIZE-NAME's
phDataset HANDLE
The handle of the ProDataset
Returns CHARACTER
The comma delimited list of buffer names
Top

CHARACTER ChildBufferNames (handle)
Purpose: Returns a comma-delimited list of the names of the child buffers
of a ProDataset buffer
Notes:

Parameters:
phBuffer HANDLE
The ProDataset buffer handle to return child buffers from
Returns CHARACTER
The comma-delimited list of the handles of the child buffers
Top

CHARACTER ChildBuffers (handle)
Purpose: Returns a comma-delimited list of the handles of the child buffers
of a ProDataset buffer
Notes:

Parameters:
phBuffer HANDLE
The ProDataset buffer handle to return child buffers from
Returns CHARACTER
The comma-delimited list of the handles of the child buffers
Top

CHARACTER ChildRelationQueryString (handle)
Purpose: Returns the query string matching a DATA-RELATION field pairs
Notes: Uses the parent table field names in the query string

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

CHARACTER ChildRelationQueryStringWithValues (handle)
Purpose: Returns the query string matching a DATA-RELATION field pairs
Notes: Instead of the parent table field names, the current buffer values are
used
When a before-buffer is passed in as phBuffer, we'll provide values based on the
before-buffer of the parent-record, when available

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

LOGICAL ChildRelationUnique (handle)
Purpose: Returns if the child buffer relation is unique
Notes:

Parameters:
phChildBuffer HANDLE
The child buffer to test for uniqueness
Returns LOGICAL
Logical value indicating the uniqueness of the child buffer
Top

HANDLE CloneDatasetWithoutSerializeHidden (handle)
Purpose: Clones the dataset without serialize hidden fields
Notes: Removes the serialize-hidden flag from all fields

Parameters:
phDataset HANDLE
The handle of the dataset to clone
Returns HANDLE
The handle of the cloned dataset
Top

LOGICAL CopyErrorStatus (handle, handle)
Purpose: Copies the error-status from the source dataset to the target dataset
Notes: Processes the BEFORE-TABLE records and assigns the ERROR, ERROR-STRING and
REJECTED attributes, expects that the hToDataset has before-table records
matching the hFromDataset

Parameters:
phFromDataset HANDLE
The handle of the source ProDataset
phToDataset HANDLE
The handle of the target ProDataset
Returns LOGICAL
Logical value indicating if there were records with an error
Top

CopyReadOnlyTables (handle, handle)
Purpose: Copies the read-only tables (no before table) from the source dataset
to the target dataset
Notes: Useful in combination with the dataset MERGE-CHANGES method to copy
also rows from tables without a before table form the source to the
target dataset. Those tables are ignored by the MERGE-CHANGES method

Parameters:
phSourceDataset HANDLE
The handle of the source dataset
phTargetDataset HANDLE
The handle of the target dataset
Top

CopyUnmodifiedRecords (handle, handle)
Purpose: Copies unmodified records from the source into the target dataset
Notes: Useful to fill a Dataset retrieved from GET-CHANGES with unmodified
records as well

Parameters:
phSourceDataset HANDLE
The handle of the source dataset
phTargetDataset HANDLE
The handle of the target dataset
Top

Consultingwerk.Util.Enum.DatasetControlStringEnum DatasetControlString (handle)
Purpose: Returns _CANCEL or _QUESTIONS-PENDING when contained in the
ERROR-STRING of at least a single record
Notes: SCL-2567

Parameters:
phDataset HANDLE
The handle of the dataset to return the error strings from
Returns Consultingwerk.Util.Enum.DatasetControlStringEnum
The control string as an DatasetControlStringEnum value
Top

Consultingwerk.RecordIdentifier DatasetErrorRecordIdentifier (handle)
Purpose: Returns the RecordIdentifier identifying the first record in the
ProDataset with Errors
Notes: Processes the Dataset in the same order as DatasetErrorStrings

Parameters:
phDataset HANDLE
The handle of the dataset to return the error strings from
Returns Consultingwerk.RecordIdentifier
The RecordIdentifier identifying the first record in the ProDataset with errors
Top

CHARACTER DatasetErrorStrings (handle)
Purpose: Returns a single CHARACTER string composed of the error-strings
of all records (from all tables in the given Dataset instance)
Notes: Filters out _CANCEL and _QUESTIONS-PENDING (SCL-2567)

Parameters:
phDataset HANDLE
The handle of the dataset to return the error strings from
Returns CHARACTER
The string composed of the error-strings of all records
Top

LONGCHAR DatasetErrorStringsLong (handle)
Purpose: Returns a single CHARACTER string composed of the error-strings
of all records (from all tables in the given Dataset instance)
Notes: Filters out _CANCEL and _QUESTIONS-PENDING (SCL-2567)

Parameters:
phDataset HANDLE
The handle of the dataset to return the error strings from
Returns LONGCHAR
The LONGCHAR string composed of the error-strings of all records
Top

HANDLE DatasetFieldHandle (handle, character, character, character)
Purpose: Returns the buffer-field handle for the given lookup field
Notes:

Parameters:
phDataset HANDLE
The ProDataset of the Business Entity
pcEntityTable CHARACTER
The name of the entity table
pcEntityView CHARACTER
The entity view tables
pcFieldName CHARACTER
The name of the lookup field
Returns HANDLE
The handle of the dataset field
Top

ROWID DatasetQueryRowids (handle, handle, rowid[])
Purpose: Extracts the Rowids from an array of ROWID's in order of Buffer-Sequence in a
ProDataset to an array of those ROWID's used in a query on buffers of the ProDataset
Notes:

Parameters:
phDataset HANDLE
The handle of the ProDataset
phQuery HANDLE
The handle of the query on buffers from the ProDataset
roRowids ROWID
The array of ProDataset buffer ROWIDs
Returns ROWID
The array of ROWIDs from the query
Top

DeleteCascade (handle)
Purpose: Deletes the record from the given ProDataset buffer and recursively
deletes all child records
Notes:

Parameters:
phBuffer HANDLE
The handle of the ProDataset buffer with the record to delete
Top

DeleteCascade (handle, logical, character)
Purpose: Deletes the record from the given ProDataset buffer and recursively
deletes all child records
Notes: Supports * as value for pcDeleteChildBuffers

Parameters:
phBuffer HANDLE
The handle of the ProDataset buffer with the record to delete
plDeleteRecord LOGICAL
Delete the actual record
pcDeleteChildBuffers CHARACTER
The comma delimited list of child buffer names to process
Top

DeleteDatasetAndBuffers (handle)
Purpose: Deletes a ProDataset object handle and all it's buffers
Notes: Useful, when dynamic buffers have been added to a ProDataset manually
any are not maintained by the ProDataset (like they would be when the
Dataset was created by the CREATE-LIKE method or similar).

Parameters:
phDataset HANDLE
The handle of the ProDataset
Top

DeleteDatasetAndTempTables (handle)
Purpose: Deletes a ProDataset object handle and all it's member temp-table
Notes:

Parameters:
phDataset HANDLE
The handle of the ProDataset
Top

DeleteOrphanedRecords (handle)
Purpose: Deletes orphaned records in the given Dataset or child table
Notes:

Parameters:
phDatasetOrBufferHandle HANDLE
The handle of the ProDataset or child table buffer
Top

DeleteOrphanedRecords (handle, logical)
Purpose: Deletes orphaned records in the given Dataset or child table
Notes:

Parameters:
phBuffer HANDLE
The handle of the ProDataset buffer to delete orphaned records in
plRecursive LOGICAL
Logical value indicating if child relations should be iterated recursively
Top

DeleteRestrict (handle)
Purpose: Deletes the record from the given ProDataset buffer only when
there is no child record
Notes: Throws an error message, when a child error still exists

Parameters:
phBuffer HANDLE
The handle of the ProDataset buffer with the record to delete
Top

DetachDataSources (handle)
Purpose: Detaches the DATA-SOURCE's of the ProDataset buffer
Notes:

Parameters:
phDataset HANDLE
The handle of the ProDataset
Top

EmptyDataset (handle)
Purpose: Empties a ProDataset
Notes: Assigns Tracking-Changes of all temp-tables to FALSE prior to
emptying the ProDataset and restores the state of Tracking-Changes
afterwards

Parameters:
phDataset HANDLE
The handle of the ProDataset
Top

HANDLE FindBufferWithField (handle, character, character)
Purpose: Find the first buffer of the list in the given ProDataset that
contains a field with the given name
Notes: Returns ? when the field is not available in any buffer

Parameters:
phDataset HANDLE
The handle of the ProDataset
pcBufferNames CHARACTER
The comma delimited list of buffer names of the ProDataset
pcFieldName CHARACTER
The unqualified name of the field to locate
Returns HANDLE
The handle of the first buffer that contains the field
Top

HANDLE GetBufferHandle (handle, character)
Purpose: Returns the handle of a ProDataset buffer by the name
Notes: Provides a meaningful error message when the buffer name is not found

Parameters:
phDataset HANDLE
The handle of the dataset
pcBufferName CHARACTER
The name of the buffer
Returns HANDLE
The handle of the Buffer
Top

HANDLE GetBufferHandles (handle)
Purpose: Returns an Array of the Buffer handles of the given Dataset
Notes: Returns an uninitialized array and not a runtime error when the dataset
does not contain any buffer

Parameters:
phDataset HANDLE
The handle of the dataset
Returns HANDLE
The Array of Buffer handles
Top

INTEGER GetBufferIndex (handle, character)
Purpose: Returns the index of the buffer name in the ProDataset
Notes: Return ? when the buffer is not a member of the ProDataset

Parameters:
phDataset HANDLE
The handle of the ProDataset
pcBufferName CHARACTER
The name of the buffer to locate
Returns INTEGER
The index of the buffer in the ProDataset buffer's list
Top

HANDLE GetChangesDataset (handle)
Purpose: Builds a dataset containing the changes records from the
source dataset.
Notes: This method returns a dataset, clean up has to be done by the
caller.

Parameters:
phDataset HANDLE
The handle of the original dataset
Returns HANDLE
The handle of a new dataset containing the changes from the original dataset
Top

HANDLE GetChildRelation (handle, character)
Purpose: Returns the handle of the child relation of a buffer by name
Notes:

Parameters:
phParentBuffer HANDLE
The handle to the parent buffer
pcDataRelationName CHARACTER
The name of the data-relation to return
Returns HANDLE
The handle of the data-relation with the matching name
Top

ROWID GetDatasetRowids (handle)
Purpose: Returns an array with the current ROWID's of every ProDataset buffer
Notes: Useful in situations where ProDataset methods such as GET-CHANGES
or MERGE-CHANGES invalidate the current record buffers

Parameters:
phDataset HANDLE
The handle of the ProDataset
Returns ROWID
The variable extent array of ROWID's matching the order of buffers in the ProDataset
Top

HANDLE GetDatasetWithCurrentRecord (handle)
Purpose: Creates a Dataset as a copy of another Dataset that only contains
the current record in the given ProDataset temp-table buffer
Notes: Useful to send individual records of a ProDataset to Business Entity
InvokeMethod or Business Task methods

Parameters:
phBuffer HANDLE
The handle of the ProDataset Buffer that contains the record to be copied
Returns HANDLE
The copy of the ProDataset, the caller is responsible to clean this up when no longer needed
Top

HANDLE GetDatasetWithoutRelations (handle)
Purpose: Returns a Dataset with the same schema but no relations
Notes:

Parameters:
phDataset HANDLE
The handle of the source dataset
Returns HANDLE
The copy of the dataset with no relations
Top

HANDLE GetDataSourceQueryHandles (handle)
Purpose: Returns an array of the Query handles of the Data-Sources of the
given Dataset
Notes: Array may contain invalid ? entries when data sources don't have a
query assigned

Parameters:
phDataset HANDLE
The handle of the ProDataset
Returns HANDLE
The handle array with the handles of the data-source queries
Top

CHARACTER GetFillWhereStrings (handle)
Purpose: Returns an array of the FILL-WHERE-STRING's of the Data-Sources of the
given Dataset
Notes: Array may contain invalid ? entries when a buffer doesn't have a data-source

Parameters:
phDataset HANDLE
The handle of the ProDataset
Returns CHARACTER
The character array with the FILL-WHERE-STRING's of the buffers data-source
Top

HANDLE GetTableHandles (handle)
Purpose: Returns an Array of the Temp-Table handles of the given Dataset
Notes: Returns an uninitialized array and not a runtime error when the dataset
does not contain any buffer

Parameters:
phDataset HANDLE
The handle of the dataset
Returns HANDLE
The Array of Temp-Table handles
Top

LOGICAL GetTrackingChanges (handle)
Purpose: Returns if the Dataset is currently TRACKING-CHANGES
Notes: Returns the value of the TRACKING-CHANGES attribute of the first
updatable temp-table. When there is not updatable temp-table, FALSE
will be returned

Parameters:
phDataset HANDLE
Handle of the dataset
Returns LOGICAL
Logical value indicating if the Dataset is TRACKING-CHANGES
Top

LOGICAL HasBuffer (handle, character)
Purpose: Returns if the the passed in ProDataset handle has a buffer with the
given name
Notes:

Parameters:
phDataset HANDLE
The handle of the ProDataset
pcBufferName CHARACTER
The name of the Buffer that should exist
Returns LOGICAL
Logical value indicating if the ProDataset has a buffer with the given name
Top

LOGICAL HasChanges (handle)
Purpose: Tests if a ProDataset has changes
Notes: Similar to the System.Data.Dataset.HasChanges attribute

Parameters:
phDataset HANDLE
Handle of the dataset
Returns LOGICAL
Logical value indicating if the ProDataset has change records (before table records)
Top

LOGICAL HasCreatedRecords (handle)
Purpose: Returns if the Dataset has records with a ROW-STATE of
ROW-CREATED
Notes:

Parameters:
phDataset HANDLE
The handle of the Dataset
Returns LOGICAL
Logical value indicating if the dataset has records with ROW-STATE = ROW-CREATED
Top

LOGICAL HasDeletedRecords (handle)
Purpose: Returns if the Dataset has records with a ROW-STATE of
ROW-DELETED
Notes:

Parameters:
phDataset HANDLE
The handle of the Dataset
Returns LOGICAL
Logical value indicating if the dataset has records with ROW-STATE = ROW-DELETED
Top

LOGICAL HasErrors (handle)
Purpose: Returns if the Dataset contains a record with an
ERROR-STRING, ERROR or REJECTED
Notes:

Parameters:
phDataset HANDLE
Tha handle of the Dataset to test
Returns LOGICAL
Logical value indicating if the dataset has errors
Top

LOGICAL HasModifiedRecords (handle)
Purpose: Returns if the Dataset has records with a ROW-STATE of
ROW-MODIFIED
Notes:

Parameters:
phDataset HANDLE
The handle of the Dataset
Returns LOGICAL
Logical value indicating if the dataset has records with ROW-STATE = ROW-MODIFIED
Top

LOGICAL HasRecursiveRelationFromTopLevelBuffer (handle)
Purpose: Checks if the ProDataset contains an active recursive
data-relation from any of the top-level buffers
Notes:

Parameters:
phDataset HANDLE
The handle of the ProDataset
Returns LOGICAL
Logical value indicating if ProDataset contains an active recursive data-relation from any of the top-level buffers
Top

LOGICAL HasRowState (handle, integer)
Purpose: Returns if the Dataset has records with a given ROW-STATE
Notes:

Parameters:
phDataset HANDLE
The handle of the Dataset
piRowState INTEGER
The INTEGER ROW-STATE value to verify
Returns LOGICAL
Logical value indicating if the dataset has records with ROW-STATE = ROW-CREATED
Top

LOGICAL HasSerializeHiddenColumns (handle)
Purpose: Returns if the Dataset contains serialize-hidden columns
Notes:

Parameters:
phDataset HANDLE
Tha handle of the Dataset to test
Returns LOGICAL
Logical value indicating if the dataset has hidden columns
Top

LOGICAL HasValidationMessages (handle)
Purpose: Returns if the ProDataset or ProDataset Buffer has
any validation messages (BUFFER ERROR-STRING)
Notes:

Parameters:
phDataHandle HANDLE
The handle of the ProDataset
Returns LOGICAL
Logical value indicating if the ProDataset or Buffer has any validation messages
Top

LOGICAL HasValidationMessages (handle, character)
Purpose: Returns if the ProDataset or ProDataset Buffer has
any validation messages (BUFFER ERROR-STRING) for the
given field name
Notes: Ignores parameters with value = ? in the evaluation

Parameters:
phDataHandle HANDLE
The handle of the ProDataset
pcFieldName CHARACTER
The name of the field to verify
Returns LOGICAL
Logical value indicating if the ProDataset or Buffer has any validation messages
Top

LOGICAL HasValidationMessages (handle, character, character)
Purpose: Returns if the ProDataset or ProDataset Buffer has
any validation messages (BUFFER ERROR-STRING) for the
given field name and the given message group and number
Notes: Ignores parameters with value = ? in the evaluation

Parameters:
phDataHandle HANDLE
The handle of the ProDataset
pcFieldName CHARACTER
The name of the field to verify
pcMessageText CHARACTER
The text of the validation message
Returns LOGICAL
Logical value indicating if the ProDataset or Buffer has any validation messages
Top

LOGICAL HasValidationMessages (handle, character, character, integer)
Purpose: Returns if the ProDataset or ProDataset Buffer has
any validation messages (BUFFER ERROR-STRING) for the
given field name and the given message group and number
Notes: Ignores parameters with value = ? in the evaluation

Parameters:
phDataHandle HANDLE
The handle of the ProDataset
pcFieldName CHARACTER
The name of the field to verify
pcMessageGroup CHARACTER
The message group
piMessageNumber INTEGER
The message number
Returns LOGICAL
Logical value indicating if the ProDataset or Buffer has any validation messages
Top

LOGICAL HasValidationMessages (handle, character, character, integer, character, character, character, character, character, character, character, character, character)
Purpose: Returns if the ProDataset or ProDataset Buffer has
any validation messages (BUFFER ERROR-STRING) for the
given field name and the given message group and number
Notes: Only substitution values <> ? will be verified, ignores
parameters with value = ? in the evaluation

Parameters:
phDataHandle HANDLE
The handle of the ProDataset
pcFieldName CHARACTER
The name of the field to verify
pcMessageGroup CHARACTER
The message group
piMessageNumber INTEGER
The message number
pcSubstitutionValue1 CHARACTER
The first message substitute value (&1)
pcSubstitutionValue2 CHARACTER
The second message substitute value (&2)
pcSubstitutionValue3 CHARACTER
The third message substitute value (&3)
pcSubstitutionValue4 CHARACTER
The fourth message substitute value (&4)
pcSubstitutionValue5 CHARACTER
The fifth message substitute value (&5)
pcSubstitutionValue6 CHARACTER
The sixth message substitute value (&6)
pcSubstitutionValue7 CHARACTER
The seventh message substitute value (&7)
pcSubstitutionValue8 CHARACTER
The eight message substitute value (&8)
pcSubstitutionValue9 CHARACTER
The ninth message substitute value (&9)
Returns LOGICAL
Logical value indicating if the ProDataset or Buffer has any validation messages
Top

LOGICAL HasValidationMessages (handle, character, integer)
Purpose: Returns if the ProDataset or ProDataset Buffer has
any validation messages (BUFFER ERROR-STRING) of the given
message group and number
Notes: Ignores parameters with value = ? in the evaluation

Parameters:
phDataHandle HANDLE
The handle of the ProDataset
pcMessageGroup CHARACTER
The message group
piMessageNumber INTEGER
The message number
Returns LOGICAL
Logical value indicating if the ProDataset or Buffer has any validation messages
Top

LOGICAL HasValidationMessages (handle, character, integer, character, character, character, character, character, character, character, character, character)
Purpose: Returns if the ProDataset or ProDataset Buffer has
any validation messages (BUFFER ERROR-STRING) of the given
message group and number with the provided substitution values
Notes: Only substitution values <> ? will be verified, ignores
parameters with value = ? in the evaluation

Parameters:
phDataHandle HANDLE
The handle of the ProDataset
pcMessageGroup CHARACTER
The message group
piMessageNumber INTEGER
The message number
pcSubstitutionValue1 CHARACTER
The first message substitute value (&1)
pcSubstitutionValue2 CHARACTER
The second message substitute value (&2)
pcSubstitutionValue3 CHARACTER
The third message substitute value (&3)
pcSubstitutionValue4 CHARACTER
The fourth message substitute value (&4)
pcSubstitutionValue5 CHARACTER
The fifth message substitute value (&5)
pcSubstitutionValue6 CHARACTER
The sixth message substitute value (&6)
pcSubstitutionValue7 CHARACTER
The seventh message substitute value (&7)
pcSubstitutionValue8 CHARACTER
The eight message substitute value (&8)
pcSubstitutionValue9 CHARACTER
The ninth message substitute value (&9)
Returns LOGICAL
Logical value indicating if the ProDataset or Buffer has any validation messages
Top

LOGICAL IsUniqueChildRelation (handle)
Purpose: Returns if the provided data-relation is pointing to an unique
child record
Notes: Returns TRUE for eOrder->eCustomer and FALSE for eOrder->eOrderLine

Parameters:
phRelation HANDLE
The handle of the DATA-RELATION to test
Returns LOGICAL
Logical value indicating if the data-relation is pointing to an unique child record
Top

MergeUnmodifiedRecords (handle, handle)
Purpose: Merges the records of the source dataset into the target dataset.
Does not overwrite modified records of the target dataset
Notes: The target dataset is expected to contain the same buffers/fields as the
source dataset

Parameters:
phSourceDataset HANDLE
The source ProDataset handle
phTargetDataset HANDLE
The target ProDataset handle
Top

HANDLE ParentBuffer (handle)
Purpose: Returns the handle of the parent buffer of a ProDataset buffer
Notes:

Parameters:
phBuffer HANDLE
The handle of the ProDataset buffer (child buffer)
Returns HANDLE
The handle of the parent buffer
Top

Consultingwerk.Framework.Collections.RowidDictionary ParentRecordRowids (handle)
Purpose: Returns a RowidDictionary with the ROWID's of the current record as
well as the parent and grand-parent ... records based on the ProDataset
relations
Notes:

Parameters:
phBuffer HANDLE
The handle of the child buffer to return the parent ROWID's for
Returns Consultingwerk.Framework.Collections.RowidDictionary
The RowidDictionary with the ROWID's of the parent records
Top

CHARACTER ParentRelationWhereStringWithTypeConversion (handle)
Purpose: Returns the where string matching a DATA-RELATION and inserts functions
for data type conversion if required
Notes:

Parameters:
phBuffer HANDLE
The child buffer of the relation
Returns CHARACTER
The query string matching the data-relation criteria with type conversion functions
Top

CHARACTER ParentRelationWhereStringWithValues (handle)
Purpose: Returns the where string matching a DATA-RELATION field pairs
Notes: Instead of the parent table field names, the current buffer values of
the child table are used in the where string

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

ReadXml (handle, character)
Purpose: Loads the given Dataset from an XML file using EMPTY mode:
clears all existing rows and then populates the dataset from the xml file.
Notes: Validates the file path via FileHelper:FindFile method.

Parameters:
phDataset HANDLE
The handle to the Dataset.
pcFileName CHARACTER
Path to the XML file.
Top

RejectNonCreateChanges (handle)
Purpose: Rejects all row-changes in the ProDatasets before tables that
do not have the row-mod of Adding
Notes: ROW-UNMODIFIED 0 The row was not modified.
ROW-DELETED 1 The row was deleted.
ROW-MODIFIED 2 The row was modified.
ROW-CREATED 3 The row was created.

Parameters:
phDataset HANDLE
The handle to the dataset
Top

RepositionDatasetBuffers (handle, rowid[])
Purpose: Locates the records in all ProDataset buffers based on an Array
of ROWID's
Notes: The input parameter proRowids can be obtained from the GetDatasetRowids
method

Parameters:
phDataset HANDLE
The handle of the ProDataset
proRowids ROWID
The variable extent array of ROWID's matching the order of buffers in the ProDataset
Top

ResolveSmartErrorMessages (handle)
Purpose: Resolves SmartMessages in the Dataset records ERROR-STRING
Notes:

Parameters:
phDataset HANDLE
The handle of the Dataset to process
Top

SanitizeErrors (handle)
Purpose: Sanitizes ProDataset ERROR-STRING and ERROR
Notes: Sets ERROR-STRING to "", ERROR and REJECTED to FALSE

Parameters:
phDataset HANDLE
Tha handle of the Dataset to sanitize errors
Top

SetControlCancel (handle)
Purpose: Sets the ERROR-STRING of a ProDataset Buffer, and the ERROR attribute
of the BUFFER and the ProDataset based on a DatasetControlStringEnum
value
Notes:

Parameters:
phBuffer HANDLE
The ProDataset Member Buffer
Top

SetControlString (handle, DatasetControlStringEnum)
Purpose: Sets the ERROR-STRING of a ProDataset Buffer, and the ERROR attribute
of the BUFFER and the ProDataset based on a DatasetControlStringEnum
value
Notes:

Parameters:
phBuffer HANDLE
The ProDataset Member Buffer
poControlString Consultingwerk.Util.Enum.DatasetControlStringEnum
The DatasetControlStringEnum value
Top

SetDataSourceQueryHandles (handle, handle[])
Purpose: Assigns the Query handles of the data-source widgets attached to the
ProDataset buffers
Notes: Ignores Cannot assign auto-generated FILL query to user FILL query. (11866)
in which case it seems safe to assign ? to the DATA-SOURCE QUERY attribute

Parameters:
phDataset HANDLE
The handle of the ProDataset
phQueries HANDLE
The array of the query handles to assign to the data-source queries
Top

SetErrorString (handle, character)
Purpose: Sets the ERROR-STRING of a ProDataset Buffer, and the ERROR attribute
of the BUFFER and the ProDataset
Notes:

Parameters:
phBuffer HANDLE
The ProDataset Member Buffer
pcErrorString CHARACTER
The Error-String
Top

SetFillWhereStrings (handle, character[])
Purpose: Assigns the FILL-WHERE-STRING's of the data-source widgets attached to the
ProDataset buffers
Notes: Ignores Cannot assign auto-generated FILL query to user FILL query. (11866)
in which case it seems safe to assign ? to the DATA-SOURCE QUERY attribute

Parameters:
phDataset HANDLE
The handle of the ProDataset
pcFillWhereStrings CHARACTER
The array of the query handles to assign to the data-source queries
Top

SetSerializeNameFromXmlNodeName (handle)
Purpose: Sets all of a dataset's SERIALIZE-NAME attributes the value of the XML-NODE-NAME
attribute. If a SERIALIZE-NAME value is the same as the NAME value, and the
XML-NODE-NAME value is different, then the SERIALIZE-NAME value will be set to the
XML-NODE-NAME.
Notes: This method is intended to be used for datasets that have been dynamically created from
an XSD file loaded with the READ-XMLSCHEMA method. The doc at
https://docs.progress.com/bundle/openedge-abl-use-xml/page/XML-NODE-NAME-and-SERIALIZE-NAME.html //docs.progress.com/bundle/openedge-abl-use-xml/page/XML-NODE-NAME-and-SERIALIZE-NAME.html
does not mention READ-XMLSCHEMA but the observed behavior matches the doc.
"All" means the dataset, all of the buffers and all of the buffers' fields

Parameters:
phDataset HANDLE
The handle to the Dataset
Top

SetTrackingChanges (handle, logical)
Purpose: Sets the tracking changes property of all temp-tables of the passed
in dataset
Notes: Tables without a valid BEFORE-BUFFER will not be handled. For static
temp-tables this is typically understood as read-only temp-tables
(and the attempt to enable TRACKING-CHANGES would cause a runtime
error). Dynamic temp-tables that have never been set to
TRACKING-CHANGES = TRUE will never have a valid BEFORE-BUFFER. As
such it's expected that dynamic temp-tables that should be updatable
will be set to TRACKING-CHANGES briefly in their factory method.

Parameters:
phDataset HANDLE
The handle to the Dataset
plTrackingChanges LOGICAL
LOGICAL value indicating if tracking changes should be turned on or off
Top

SetTrackingChanges (handle, logical, DynamicTempTablesEnum)
Purpose: Sets the tracking changes property of all temp-tables of the passed
in dataset
Notes: Tables without a valid BEFORE-BUFFER will not be handled. For static
temp-tables this is typically understood as read-only temp-tables
(and the attempt to enable TRACKING-CHANGES would cause a runtime
error). Dynamic temp-tables that have never been set to
TRACKING-CHANGES = TRUE will never have a valid BEFORE-BUFFER.
The poDynamicTempTables parameter allows to indicate how to handle
dynamic temp-tables

Parameters:
phDataset HANDLE
The handle to the Dataset
plTrackingChanges LOGICAL
LOGICAL value indicating if tracking changes should be turned on or off
poDynamicTempTables Consultingwerk.Util.Enum.DynamicTempTablesEnum
The DynamicTempTablesEnum value indicating how to handle dynamic temp-tables
Top

CHARACTER SiblingWhereStringWithValues (handle)
Purpose: Returns the where string matching a DATA-RELATION field pairs for a child buffer
of the FOR EACH for a parent buffer
Notes:

Parameters:
phBuffer HANDLE
The current buffer
Returns CHARACTER
The query string
Top

ThrowDatasetErrors (handle)
Purpose: Throws Dataset Validation error messages from the ERROR-STRING
attributes of any record
Notes: Performs no action, when there is no record with an ERROR-STRING in
the ProDataset
SCL-496
Throws: Consultingwerk.Exceptions.DatasetException

Parameters:
phDataset HANDLE
The handle to the Dataset


Constructor Detail
Top

DatasetHelper ()
Purpose: Protected default constructor.
Notes: There's no need to create instances of the helper classes



©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       30.03.2026 11:13:09