Namespace: Consultingwerk.OERA
Class 
GenericFetchDataByKeyTableParameter Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.OERA.GenericFetchDataByKeyTableParameter

Inherits: Progress.Lang.Object
Implements: Consultingwerk.OERA.IFetchDataByKeyTableParameter
USE-WIDGET-POOL

File:GenericFetchDataByKeyTableParameter
Purpose:General purpose parameter class for the FetchDataByKeyTable
method of the BusinessEntity and DataAccess class
Description:Removes the need to build a specialized parameter class
for this method
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Tue Nov 20 21:41:40 CET 2018

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



Top Method Summary
Options Name Purpose
+ CreateField (character, character) Creates a field in the temp-table
+ HANDLE CreateRecord () Creates a record in the key table
+ HANDLE CreateRecord (character) Creates a record in the key table
+ HANDLE CreateRecord (character, character) Creates a record in the key table
+ HANDLE CreateRecord (character, character, character) Creates a record in the key table
+ HANDLE CreateRecord (character, character, integer) Creates a record in the key table
+ HANDLE CreateRecord (character, integer) Creates a record in the key table
+ HANDLE CreateRecord (character, integer, character) Creates a record in the key table
+ HANDLE CreateRecord (character, integer, integer) Creates a record in the key table
+ HANDLE CreateRecord (character, logical) Creates a record in the key table
+ HANDLE CreateRecord (date) Creates a record in the key table
+ HANDLE CreateRecord (date, date) Creates a record in the key table
+ HANDLE CreateRecord (date, date, date) Creates a record in the key table
+ HANDLE CreateRecord (datetime) Creates a record in the key table
+ HANDLE CreateRecord (datetime, datetime) Creates a record in the key table
+ HANDLE CreateRecord (datetime, datetime, datetime) Creates a record in the key table
+ HANDLE CreateRecord (datetime-tz) Creates a record in the key table
+ HANDLE CreateRecord (datetime-tz, datetime-tz) Creates a record in the key table
+ HANDLE CreateRecord (datetime-tz, datetime-tz, datetime-tz) Creates a record in the key table
+ HANDLE CreateRecord (decimal) Creates a record in the key table
+ HANDLE CreateRecord (decimal, decimal) Creates a record in the key table
+ HANDLE CreateRecord (decimal, decimal, decimal) Creates a record in the key table
+ HANDLE CreateRecord (int64) Creates a record in the key table
+ HANDLE CreateRecord (int64, int64) Creates a record in the key table
+ HANDLE CreateRecord (int64, int64, int64) Creates a record in the key table
+ HANDLE CreateRecord (integer) Creates a record in the key table
+ HANDLE CreateRecord (integer, character) Creates a record in the key table
+ HANDLE CreateRecord (integer, character, character) Creates a record in the key table
+ HANDLE CreateRecord (integer, character, integer) Creates a record in the key table
+ HANDLE CreateRecord (integer, integer) Creates a record in the key table
+ HANDLE CreateRecord (integer, integer, character) Creates a record in the key table
+ HANDLE CreateRecord (integer, integer, integer) Creates a record in the key table
+ HANDLE CreateRecord (integer, logical) Creates a record in the key table
+ HANDLE CreateRecord (logical) Creates a record in the key table
+ HANDLE CreateRecord (logical, character) Creates a record in the key table
+ HANDLE CreateRecord (logical, integer) Creates a record in the key table
+ HANDLE CreateRecord (logical, logical) Creates a record in the key table
+ HANDLE CreateRecord (logical, logical, logical) Creates a record in the key table
# InitializeKeyTable () Initializes the Key Table

Top Constructor Summary
Options Name Purpose
+ GenericFetchDataByKeyTableParameter (character) Constructor for the GenericFetchDataByKeyTableParameter class

Top Property Summary
Options Name Purpose
+ HANDLE KeyValueTableHandle
+ CHARACTER Tables


Method Detail
Top

PUBLIC CreateField (character, character)
Purpose: Creates a field in the temp-table
Notes:

Parameters:
pcFieldName CHARACTER
The name of the field to create
pcDataType CHARACTER
The data type for the new field
Top

PUBLIC HANDLE CreateRecord ()
Purpose: Creates a record in the key table
Notes:

Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (character)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 CHARACTER
The value for the first key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (character, character)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 CHARACTER
The value for the first key field
pValue2 CHARACTER
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (character, character, character)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 CHARACTER
The value for the first key field
pValue2 CHARACTER
The value for the second key field
pValue3 CHARACTER
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (character, character, integer)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 CHARACTER
The value for the first key field
pValue2 CHARACTER
The value for the second key field
pValue3 INTEGER
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (character, integer)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 CHARACTER
The value for the first key field
pValue2 INTEGER
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (character, integer, character)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 CHARACTER
The value for the first key field
pValue2 INTEGER
The value for the second key field
pValue3 CHARACTER
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (character, integer, integer)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 CHARACTER
The value for the first key field
pValue2 INTEGER
The value for the second key field
pValue3 INTEGER
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (character, logical)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 CHARACTER
The value for the first key field
pValue2 LOGICAL
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (date)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DATE
The value for the first key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (date, date)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DATE
The value for the first key field
pValue2 DATE
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (date, date, date)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DATE
The value for the first key field
pValue2 DATE
The value for the second key field
pValue3 DATE
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (datetime)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DATETIME
The value for the first key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (datetime, datetime)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DATETIME
The value for the first key field
pValue2 DATETIME
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (datetime, datetime, datetime)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DATETIME
The value for the first key field
pValue2 DATETIME
The value for the second key field
pValue3 DATETIME
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (datetime-tz)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DATETIME-TZ
The value for the first key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (datetime-tz, datetime-tz)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DATETIME-TZ
The value for the first key field
pValue2 DATETIME-TZ
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (datetime-tz, datetime-tz, datetime-tz)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DATETIME-TZ
The value for the first key field
pValue2 DATETIME-TZ
The value for the second key field
pValue3 DATETIME-TZ
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (decimal)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DECIMAL
The value for the first key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (decimal, decimal)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DECIMAL
The value for the first key field
pValue2 DECIMAL
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (decimal, decimal, decimal)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 DECIMAL
The value for the first key field
pValue2 DECIMAL
The value for the second key field
pValue3 DECIMAL
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (int64)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INT64
The value for the first key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (int64, int64)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INT64
The value for the first key field
pValue2 INT64
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (int64, int64, int64)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INT64
The value for the first key field
pValue2 INT64
The value for the second key field
pValue3 INT64
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (integer)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INTEGER
The value for the first key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (integer, character)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INTEGER
The value for the first key field
pValue2 CHARACTER
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (integer, character, character)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INTEGER
The value for the first key field
pValue2 CHARACTER
The value for the second key field
pValue3 CHARACTER
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (integer, character, integer)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INTEGER
The value for the first key field
pValue2 CHARACTER
The value for the second key field
pValue3 INTEGER
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (integer, integer)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INTEGER
The value for the first key field
pValue2 INTEGER
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (integer, integer, character)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INTEGER
The value for the first key field
pValue2 INTEGER
The value for the second key field
pValue3 CHARACTER
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (integer, integer, integer)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INTEGER
The value for the first key field
pValue2 INTEGER
The value for the second key field
pValue3 INTEGER
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (integer, logical)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 INTEGER
The value for the first key field
pValue2 LOGICAL
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (logical)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 LOGICAL
The value for the first key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (logical, character)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 LOGICAL
The value for the first key field
pValue2 CHARACTER
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (logical, integer)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 LOGICAL
The value for the first key field
pValue2 INTEGER
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (logical, logical)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 LOGICAL
The value for the first key field
pValue2 LOGICAL
The value for the second key field
Returns HANDLE
The handle of the buffer with the new record
Top

PUBLIC HANDLE CreateRecord (logical, logical, logical)
Purpose: Creates a record in the key table
Notes:

Parameters:
pValue1 LOGICAL
The value for the first key field
pValue2 LOGICAL
The value for the second key field
pValue3 LOGICAL
The value for the third key field
Returns HANDLE
The handle of the buffer with the new record
Top

PROTECTED InitializeKeyTable ()
Purpose: Initializes the Key Table
Notes:



Constructor Detail
Top

PUBLIC GenericFetchDataByKeyTableParameter (character)
Purpose: Constructor for the GenericFetchDataByKeyTableParameter class
Notes:

Parameters:
pcTables CHARACTER
The value for the Tables property


Property Detail
Top

PUBLIC HANDLE KeyValueTableHandle

Returns HANDLE
Top

PUBLIC CHARACTER Tables

Returns CHARACTER


©2006-2019 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       08.08.2019 23:28:42