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

File:BufferHelper
Syntax:Static methods only, private constructor to disallow
instance creation
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Wed Sep 30 14:43:37 CEST 2009



Top Method Summary
Options Name Purpose
+ AddBufferFieldsToList (handle, ListNameValuePair, logical) Adds the fields from the given Buffer Handle to the given ListNameValuePair
+ CHARACTER AllFieldNames (handle) Returns a comma-delimited list of the buffer column names
+ CHARACTER AllFieldsFindPredicate (handle) Builds a QueryString predicate that can be used to (re)fetch a record based on equality of all fields @param phBuffer The handle of the buffer @return The QueryString predicate */
+ CHARACTER BufferFieldSubstitute (handle, character, character) Returns the result of a SUBSTITUTE function based on fields of a buffer handle
+ CHARACTER BufferFieldSubstitute (handle, character, character, logical) Returns the result of a SUBSTITUTE function based on fields of a buffer handle
+ CHARACTER BufferFieldSubstituteFormatted (handle, character, character, character) Returns the result of a SUBSTITUTE function based on formatted fields of a buffer handle
+ HANDLE BufferHandle (BufferFieldName) Returns the handle to the database buffer referenced by the BufferFieldName object
+ CHARACTER BufferIndexByClause (handle, character, logical) Returns the by clause mathing a buffer index
+ CHARACTER BufferIndexByClause (handle, character, logical, logical) Returns the by clause mathing a buffer index
+ CHARACTER BufferIndexFields (handle, character) Returns the list of fields referenced in an index
+ CHARACTER BufferLargeColumns (handle) Returns the large columns from the given buffer handle
+ LOGICAL CanCreateDefaultRow (handle) Validates that a record can be created using the default values
+ HANDLE CreateBuffer (BufferFieldName) Creates and returns a dynamic buffer based on a BufferFieldName object
+ HANDLE CreateBuffer (handle) Creates a Dynamic buffer on the fly
+ FindAfterBuffer (handle) Finds the before buffer's after-buffer record
+ FindBeforeBuffer (handle) Finds the after buffer's before-buffer record
+ FindDatabaseBuffer (handle, handle, character) Finds the database record for a linked (ProDataset data-source) record in a ProDataset.
+ GetFieldNameAndExtent (character, character, integer) Returns the name and extent of the field name
+ Consultingwerk.Framework.Collections.CharacterDictionary GetFieldValues (handle, character) Returns a dictionary with field values of the given buffer
+ LOGICAL HasField (handle, character) Tests if the passed in buffer handle has a field with the given name
+ LOGICAL IsDatabaseBuffer (handle) Returns TRUE when the passed in Buffer Handle is a buffer handle for a database table
+ LOGICAL IsUniqueFieldCombination (handle, character) Returns if the provided list of field names is unqiue
+ CHARACTER NewGuidWhenEmpty (handle, character) Assigns a new GUID value to a buffer field when the buffer field is empty or ?
+ NullifyUniqueIndexFields (handle) Nullify (?) all unique index field values
+ INTEGER NumRecords (handle) Returns the number of records available in the Buffer
+ Consultingwerk.BufferFieldName ParseFieldName (character) Parses a field name
+ ParseSaxAttributesToBuffer (handle, handle) Assigns buffer field values from SAX-ATTRIBUTES
+ CHARACTER QualifiedTableName (handle) Returns the qualified table name of a buffer
+ ShowBuffer (handle) Shows buffer field values on the screen using the MESSAGE statement
+ ShowBuffer (handle, integer) Shows buffer field values on the screen using the MESSAGE statement
+ INTEGER TotalNumberOfFields (handle) Returns the total number of fields in a Buffer including Array fields as individual columns
+ CHARACTER UniqueFindPredicate (handle) Builds a QueryString predicate that can be used to (re)fetch a record based on equality of primary unique columns
+ CHARACTER UniqueFindPredicate (handle, character) Builds a QueryString predicate that can be used to (re)fetch a record based on equality of primary unique columns
+ CHARACTER UniqueFindPredicate (handle, CellsCollection) Builds a QueryString predicate that can be used to (re)fetch a record based on equality of primary unique columns Uses the buffer handle to determine the Unique Index fields, uses an UltraGrid's cell collection (i.e. of an UltraGridRow) to access the values
+ CHARACTER UniqueFindPredicate (handle, CellsCollection, UltraGridRow, logical) Builds a QueryString predicate that can be used to (re)fetch a record based on equality of primary unique columns Uses the buffer handle to determine the Unique Index fields, uses an UltraGrid's cell collection (i.e. of an UltraGridRow) to access the field/cell values
+ CHARACTER UniqueFindPredicate (handle, CellsCollection, logical) Builds a QueryString predicate that can be used to (re)fetch a record based on equality of primary unique columns Uses the buffer handle to determine the Unique Index fields, uses an UltraGrid's cell collection (i.e. of an UltraGridRow) to access the field/cell values
+ CHARACTER UniqueFindPredicate (handle, CellsCollection, logical, logical) Builds a QueryString predicate that can be used to (re)fetch a record based on equality of primary unique columns Uses the buffer handle to determine the Unique Index fields, uses an UltraGrid's cell collection (i.e. of an UltraGridRow) to access the field/cell values
+ CHARACTER UniqueFindPredicate (handle, logical) Builds a QueryString predicate that can be used to (re)fetch a record based on equality of primary unique columns
+ CHARACTER UniqueFindPredicateWithValueBuffer (handle, handle, character) Builds a QueryString predicate that can be used to (re)fetch a record based on equality of primary unique columns
+ CHARACTER UniqueFindPredicateWithValueBuffer (handle, handle, CharacterDictionary, character) Builds a QueryString predicate that can be used to (re)fetch a record based on equality of primary unique columns
+ CHARACTER UniqueKeyFields (handle) Returns the fields of the Unique Primary of the table
+ CHARACTER UniqueKeyFields (handle, logical) Returns the fields of the Unique Primary of the table
+ CHARACTER UniqueKeyFields (handle, logical, logical) Returns the fields of the Unique Primary of the table
+ CHARACTER UniqueRecordIdentifier (handle) Builds and returns a unique record identifier composed from field values of either the primary unique index or the first unqiue index of the table
+ CHARACTER UniqueRecordIdentifier (handle, logical, character) Builds and returns a unique record identifier composed from field values of either the primary unique index or the first unqiue index of the table

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


Method Detail
Top

PUBLIC AddBufferFieldsToList (handle, ListNameValuePair, logical)

Purpose: Adds the fields from the given Buffer Handle to the given ListNameValuePair
Notes: Raises an error, when no record is available in the Buffer Handle
Does not add BLOB fields

Parameters:
phBuffer HANDLE
Then HANDLE of the Buffer that holds the record to log
poList Consultingwerk.ListNameValuePair
The reference to an instance of the ListNameValuePair class
plPrefixWithBuffer LOGICAL
Logical value indicating if field names should be prefixed with the table name
Top

PUBLIC CHARACTER AllFieldNames (handle)

Purpose: Returns a comma-delimited list of the buffer column names
Notes:

Parameters:
phBuffer HANDLE
The buffer handle
Returns CHARACTER
The comma-delimited list of the buffer's column names
Top

PUBLIC CHARACTER AllFieldsFindPredicate (handle)

Purpose: Builds a QueryString predicate that can be used to (re)fetch a
record based on equality of all fields

Parameters:
phBuffer HANDLE
The handle of the buffer
Returns CHARACTER
The QueryString predicate
Top

PUBLIC CHARACTER BufferFieldSubstitute (handle, character, character)

Purpose: Returns the result of a SUBSTITUTE function based on fields of a
buffer handle
Notes: Defaults to use the STRING-VALUE, not the BUFFER-VALUE

Parameters:
phBuffer HANDLE
The Buffer handle that contains the fields
pcFields CHARACTER
The comma delimited list of the fields
pcSubstitute CHARACTER
The pattern for the SUBSTITUTE function
Returns CHARACTER
The resulting string
Top

PUBLIC CHARACTER BufferFieldSubstitute (handle, character, character, logical)

Purpose: Returns the result of a SUBSTITUTE function based on fields of a
buffer handle
Notes:

Parameters:
phBuffer HANDLE
The Buffer handle that contains the fields
pcFields CHARACTER
The comma delimited list of the fields
pcSubstitute CHARACTER
The pattern for the SUBSTITUTE function
plUseStringValue LOGICAL
True to use the STRING-VALUE, false to use the BUFFER-VALUE
Returns CHARACTER
The resulting string
Top

PUBLIC CHARACTER BufferFieldSubstituteFormatted (handle, character, character, character)

Purpose: Returns the result of a SUBSTITUTE function based on formatted fields of a
buffer handle
Notes:

Parameters:
phBuffer HANDLE
The Buffer handle that contains the fields
pcFields CHARACTER
The comma delimited list of the fields
pcSubstitute CHARACTER
The pattern for the SUBSTITUTE function
pcFormats CHARACTER
The formats to apply to the fields, delimited by the Tilde
Returns CHARACTER
The resulting string
Top

PUBLIC HANDLE BufferHandle (BufferFieldName)

Purpose: Returns the handle to the database buffer referenced by the
BufferFieldName object
Notes:

Parameters:
poBufferFieldName Consultingwerk.BufferFieldName
The reference to the BufferFieldName object
Returns HANDLE
The handle to the buffer references by the BufferFieldName object
Top

PUBLIC CHARACTER BufferIndexByClause (handle, character, logical)

Purpose: Returns the by clause mathing a buffer index
Notes:

Parameters:
phBuffer HANDLE
The handle of the buffer
pcIndexName CHARACTER
The name of the index
plIncludeBuffer LOGICAL
Include buffer name in by clause
Returns CHARACTER
The by clause mathing the index sort
Top

PUBLIC CHARACTER BufferIndexByClause (handle, character, logical, logical)

Purpose: Returns the by clause mathing a buffer index
Notes:

Parameters:
phBuffer HANDLE
The handle of the buffer
pcIndexName CHARACTER
The name of the index
plIncludeBuffer LOGICAL
Include buffer name in by clause
plReverseOrder LOGICAL
Return reverse sort order (ASCENDING -> DESCENDING, DESCENDING -> ASCENDING)
Returns CHARACTER
The by clause mathing the index sort
Top

PUBLIC CHARACTER BufferIndexFields (handle, character)

Purpose: Returns the list of fields referenced in an index
Notes:

Parameters:
phBuffer HANDLE
The handle of the buffer
pcIndexName CHARACTER
The name of the index
Returns CHARACTER
The comma delimited list of index fields
Top

PUBLIC CHARACTER BufferLargeColumns (handle)

Purpose: Returns the large columns from the given buffer handle
Notes: Used by QueryHelper:QueryLargeColumns

Parameters:
phBuffer HANDLE
The handle of the Buffer
Returns CHARACTER
The comma delimited list of large column names
Top

PUBLIC LOGICAL CanCreateDefaultRow (handle)

Purpose: Validates that a record can be created using the default values
Notes: Checks if there is already a record matching the fields in the
Unique Indexes

Parameters:
phBuffer HANDLE
The buffer handle
Returns LOGICAL
Logical value indicating if a record with default values can be created
Top

PUBLIC HANDLE CreateBuffer (BufferFieldName)

Purpose: Creates and returns a dynamic buffer based on a BufferFieldName object
Notes: The caller is expected to delete the buffer object handle when it's
no longer needed

Parameters:
poBufferFieldName Consultingwerk.BufferFieldName
The BufferFieldName reference
Returns HANDLE
The handle of the dynamic buffer
Top

PUBLIC HANDLE CreateBuffer (handle)

Purpose: Creates a Dynamic buffer on the fly
Notes: Useful to pass a new buffer handle without the need to define a
variable upfront (e.g. ProDataset:ADD-BUFFER, etc.)

Parameters:
phTable HANDLE
The handle of the table or existing buffer which can specify the source for which to create the buffer object
Returns HANDLE
The handle of the new dynamic buffer
Top

PUBLIC FindAfterBuffer (handle)

Purpose: Finds the before buffer's after-buffer record
Notes:

Parameters:
phBeforeBuffer HANDLE
The handle of the before buffer
Top

PUBLIC FindBeforeBuffer (handle)

Purpose: Finds the after buffer's before-buffer record
Notes:

Parameters:
phAfterBuffer HANDLE
The handle of the after buffer
Top

PUBLIC FindDatabaseBuffer (handle, handle, character)

Purpose: Finds the database record for a linked (ProDataset data-source) record
in a ProDataset.
Notes: Uses the PUK or first UK of the database record with the field values
of the ProDataset buffer, based on the provided field mapping

Parameters:
phBuffer HANDLE
The database buffer to locate
phDatasetBuffer HANDLE
The dataset (before or after) buffer
pcFieldMapping CHARACTER
The field mapping between database and temp-table (ATTACH-DATA-SOURCE method)
Top

PUBLIC GetFieldNameAndExtent (character, character, integer)

Purpose: Returns the name and extent of the field name
Notes:

Parameters:
pcField CHARACTER
The field name, including extent if present
pcFieldName CHARACTER
OUTPUT Just the field name portion
piExtent INTEGER
OUTPUT The field extent or 0 when the field name did not contain extent information
Top

PUBLIC Consultingwerk.Framework.Collections.CharacterDictionary GetFieldValues (handle, character)

Purpose: Returns a dictionary with field values of the given buffer
Notes:

Parameters:
phBuffer HANDLE
The handle of the buffer
pcFieldNames CHARACTER
The comma delimited list of field names to return the values for
Returns Consultingwerk.Framework.Collections.CharacterDictionary
The CharcaterDictionary with the field values
Top

PUBLIC LOGICAL HasField (handle, character)

Purpose: Tests if the passed in buffer handle has a field with the
given name
Notes: Verifies that a valid buffer is passed in first.

Parameters:
phBuffer HANDLE
The Buffer handle to test
pcFieldName CHARACTER
The name of the buffer field
Returns LOGICAL
Logical value indicating if the field exists
Top

PUBLIC LOGICAL IsDatabaseBuffer (handle)

Purpose: Returns TRUE when the passed in Buffer Handle is a buffer handle for
a database table
Notes:

Parameters:
phBuffer HANDLE
The buffer handle to test
Returns LOGICAL
Logical value indicating if the buffer handle is for a database buffer
Top

PUBLIC LOGICAL IsUniqueFieldCombination (handle, character)

Purpose: Returns if the provided list of field names is unqiue
Notes: Tests if there is an unique index defined for the buffer
where all index fields are contained in the list of fields
Base for the DatasetHelper:IsUniqueChildRelation method

Parameters:
phBuffer HANDLE
The handle of the Buffer (database or temp-table) to test for
pcFields CHARACTER
The comma delimited list of fields to test for
Returns LOGICAL
Logical value indicating if the provided field combination satisfies a unique index
Top

PUBLIC CHARACTER NewGuidWhenEmpty (handle, character)

Purpose: Assigns a new GUID value to a buffer field when the buffer field is
empty or ?
Notes: Useful in a Data Access class, to conditionally assign a GUID when
the client might or might not have done so yet

Parameters:
phBuffer HANDLE
The Buffer handle
pcFieldName CHARACTER
The name of the buffer field (type CHARACTER)
Returns CHARACTER
The GUID value (either existing in the buffer field or the new value)
Top

PUBLIC NullifyUniqueIndexFields (handle)

Purpose: Nullify (?) all unique index field values
Notes: This methods can be used when creating records, but there is already
a record in the table, that uses the default values of some index fields

Parameters:
phBuffer HANDLE
The buffer handle
Top

PUBLIC INTEGER NumRecords (handle)

Purpose: Returns the number of records available in the Buffer
Notes:

Parameters:
phBuffer HANDLE
The buffer handle
Returns INTEGER
The number of records available in the buffer
Top

PUBLIC Consultingwerk.BufferFieldName ParseFieldName (character)

Purpose: Parses a field name
Notes: Supports db.table.field, table.field, field with and without index (extent)

Parameters:
pcFieldName CHARACTER
The field name to parse
Returns Consultingwerk.BufferFieldName
The Consultingwerk.BufferFieldName struct describing the field name
Top

PUBLIC ParseSaxAttributesToBuffer (handle, handle)

Purpose: Assigns buffer field values from SAX-ATTRIBUTES
Notes:

Parameters:
phBuffer HANDLE
The handle to the buffer to assign the field values to
phSaxAttributes HANDLE
The handle of the SAX-ATTRIBUTES widget
Top

PUBLIC CHARACTER QualifiedTableName (handle)

Purpose: Returns the qualified table name of a buffer
Notes: For a DB buffer the qualified table name is prefixed with the database name
For a temp-table buffer the qualified table name is the same as the temp-table name

Parameters:
phBuffer HANDLE
The handle of the buffer
Returns CHARACTER
The qualified table name
Top

PUBLIC ShowBuffer (handle)

Purpose: Shows buffer field values on the screen using the MESSAGE statement
Notes: Defaults to show the first 15 fields

Parameters:
phBuffer HANDLE
The handle of the Buffer to output
Top

PUBLIC ShowBuffer (handle, integer)

Purpose: Shows buffer field values on the screen using the MESSAGE statement
Notes: When number of fields is 0 all fields will be shown

Parameters:
phBuffer HANDLE
The handle of the Buffer to output
piNumFields INTEGER
The maximum number of fields to show
Top

PUBLIC INTEGER TotalNumberOfFields (handle)

Purpose: Returns the total number of fields in a Buffer including Array
fields as individual columns
Notes:

Parameters:
phBuffer HANDLE
The handle to the buffer
Returns INTEGER
The total number of columns, including array extents
Top

PUBLIC CHARACTER UniqueFindPredicate (handle)

Purpose: Builds a QueryString predicate that can be used to (re)fetch a
record based on equality of primary unique columns
Notes: Returns "" when there is no primary unique index.

Parameters:
phBuffer HANDLE
The handle of the buffer
Returns CHARACTER
The query string predicate
Top

PUBLIC CHARACTER UniqueFindPredicate (handle, character)

Purpose: Builds a QueryString predicate that can be used to (re)fetch a
record based on equality of primary unique columns
Notes: Returns "" when there is no primary unique index.

Parameters:
phBuffer HANDLE
The handle of the buffer
pcBufferName CHARACTER
The Buffer name to prefix fields with, leave empty to not apply the fields with a buffer name
Returns CHARACTER
The query string predicate
Top

PUBLIC CHARACTER UniqueFindPredicate (handle, CellsCollection)

Purpose: Builds a QueryString predicate that can be used to (re)fetch a
record based on equality of primary unique columns
Uses the buffer handle to determine the Unique Index fields, uses
an UltraGrid's cell collection (i.e. of an UltraGridRow) to access
the values
Notes: Returns "" when there is no primary unique index.

Parameters:
phBuffer HANDLE
The Handle to the buffer to return the FIND predicate for
poCells Infragistics.Win.UltraWinGrid.CellsCollection
The reference to the Cells collection (of an UltraGridRow) that contains the values
Returns CHARACTER
The query string predicate
Top

PUBLIC CHARACTER UniqueFindPredicate (handle, CellsCollection, UltraGridRow, logical)

Purpose: Builds a QueryString predicate that can be used to (re)fetch a
record based on equality of primary unique columns
Uses the buffer handle to determine the Unique Index fields, uses
an UltraGrid's cell collection (i.e. of an UltraGridRow) to access
the field/cell values
Notes: Returns "" when there is no primary unique index.

Parameters:
phBuffer HANDLE
The Handle to the buffer to return the FIND predicate for
poCells Infragistics.Win.UltraWinGrid.CellsCollection
The reference to the Cells collection (of an UltraGridRow) that contains the values
poRow Infragistics.Win.UltraWinGrid.UltraGridRow
Not used, ignored
plIncludeBufferName LOGICAL
Logical value indicating if the FIND predicate should be fully quallified including buffer names
Returns CHARACTER
The query string predicate
Top

PUBLIC CHARACTER UniqueFindPredicate (handle, CellsCollection, logical)

Purpose: Builds a QueryString predicate that can be used to (re)fetch a
record based on equality of primary unique columns
Uses the buffer handle to determine the Unique Index fields, uses
an UltraGrid's cell collection (i.e. of an UltraGridRow) to access
the field/cell values
Notes: Returns "" when there is no primary unique index.

Parameters:
phBuffer HANDLE
The Handle to the buffer to return the FIND predicate for
poCells Infragistics.Win.UltraWinGrid.CellsCollection
The reference to the Cells collection (of an UltraGridRow) that contains the values
plIncludeBufferName LOGICAL
Logical value indicating if the FIND predicate should be fully quallified including buffer names
Returns CHARACTER
The query string predicate
Top

PUBLIC CHARACTER UniqueFindPredicate (handle, CellsCollection, logical, logical)

Purpose: Builds a QueryString predicate that can be used to (re)fetch a
record based on equality of primary unique columns
Uses the buffer handle to determine the Unique Index fields, uses
an UltraGrid's cell collection (i.e. of an UltraGridRow) to access
the field/cell values
Notes: Returns "" when there is no primary unique index.

Parameters:
phBuffer HANDLE
The Handle to the buffer to return the FIND predicate for
poCells Infragistics.Win.UltraWinGrid.CellsCollection
The reference to the Cells collection (of an UltraGridRow) that contains the values
plIncludeBufferName LOGICAL
Logical value indicating if the FIND predicate should be fully quallified including buffer names
plUseFullFieldNames LOGICAL
Logical value indicating if the ProBindingSource is using the UseFullFieldNames feature
Returns CHARACTER
The query string predicate
Top

PUBLIC CHARACTER UniqueFindPredicate (handle, logical)

Purpose: Builds a QueryString predicate that can be used to (re)fetch a
record based on equality of primary unique columns
Notes: Returns "" when there is no primary unique index.

Parameters:
phBuffer HANDLE
The handle of the buffer
plIncludeBufferName LOGICAL
Logical value indicating if the buffer name should be included in the field names
Returns CHARACTER
The query string predicate
Top

PUBLIC CHARACTER UniqueFindPredicateWithValueBuffer (handle, handle, character)

Purpose: Builds a QueryString predicate that can be used to (re)fetch a
record based on equality of primary unique columns
Notes: Returns "" when there is no primary unique index.

Parameters:
phBuffer HANDLE
The handle of the buffer
phValueBuffer HANDLE
The buffer to access field values from
pcBufferName CHARACTER
The Buffer name to prefix fields with, leave empty to not apply the fields with a buffer name
Returns CHARACTER
The query string predicate
Top

PUBLIC CHARACTER UniqueFindPredicateWithValueBuffer (handle, handle, CharacterDictionary, character)

Purpose: Builds a QueryString predicate that can be used to (re)fetch a
record based on equality of primary unique columns
Notes: Returns "" when there is no primary unique index.

Parameters:
phBuffer HANDLE
The handle of the buffer
phValueBuffer HANDLE
The buffer to access field values from
poMissingValues Consultingwerk.Framework.Collections.CharacterDictionary
The dictionary of character values for index fields from the phBuffer not present in phValueBuffer
pcBufferName CHARACTER
The Buffer name to prefix fields with, leave empty to not apply the fields with a buffer name
Returns CHARACTER
The query string predicate
Top

PUBLIC CHARACTER UniqueKeyFields (handle)

Purpose: Returns the fields of the Unique Primary of the table
Notes: Same as UniqueKeyFields (phBuffer, TRUE, FALSE)

Parameters:
phBuffer HANDLE
The Buffer Handle
Returns CHARACTER
The a comma-delimited list of the unique fields of the table
Top

PUBLIC CHARACTER UniqueKeyFields (handle, logical)

Purpose: Returns the fields of the Unique Primary of the table
Notes: Same as UniqueKeyFields (phBuffer, plPrimaryOnly, FALSE)

Parameters:
phBuffer HANDLE
The Buffer Handle
plPrimaryOnly LOGICAL
Only return the fields of a primary unique index
Returns CHARACTER
The a comma-delimited list of the unique fields of the table
Top

PUBLIC CHARACTER UniqueKeyFields (handle, logical, logical)

Purpose: Returns the fields of the Unique Primary of the table
Notes:

Parameters:
phBuffer HANDLE
The Buffer Handle
plPrimaryOnly LOGICAL
Only return the fields of a primary unique index
plPrefixWithTable LOGICAL
Prefix field names with Table/Buffer name
Returns CHARACTER
The a comma-delimited list of the unique fields of the table
Top

PUBLIC CHARACTER UniqueRecordIdentifier (handle)

Purpose: Builds and returns a unique record identifier composed from field
values of either the primary unique index or the first unqiue index
of the table
Notes: Calls UniqueRecordIdentifier (phBuffer, TRUE, CHR(1))

Parameters:
phBuffer HANDLE
The handle of the buffer that contains the record
Returns CHARACTER
An identifier for the records based on unique index values
Top

PUBLIC CHARACTER UniqueRecordIdentifier (handle, logical, character)

Purpose: Builds and returns a unique record identifier composed from field
values of either the primary unique index or the first unqiue index
of the table
Notes: The purpose of this method is to build a unique reusable identifier
for a record that is not dependent on a ROWID (temp-table ROWID's are
no suited record identifiers)

Parameters:
phBuffer HANDLE
The handle of the buffer that contains the record
plPrimaryOnly LOGICAL
Logical value indicating if only the primary index should be used
pcDelimiter CHARACTER
The delimiter to use for the field values
Returns CHARACTER
An identifier for the records based on unique index values


Constructor Detail
Top

PROTECTED BufferHelper ()

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



©2006-2016 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       26.08.2016 08:46:16