Namespace: Consultingwerk.OERA
Class 
NamedQueryParameterList Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.Framework.Base.GenericList
Consultingwerk.OERA.NamedQueryParameterList

Inherits: Consultingwerk.Framework.Base.GenericList
Implements: Consultingwerk.Framework.Base.IArrayList, Consultingwerk.Framework.Base.IEnumerable, Consultingwerk.Framework.Base.ISupportsListChanged, Consultingwerk.Framework.Base.ISupportsListHash

File:NamedQueryParameterList
Purpose:List of parameters to named queries
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Sun Sep 13 12:32:58 CEST 2015
Notes:SCL-1018
Implemented as a List, as Dictionaries are currently not
serializable. But provides dictionary methods ContainsKey
and GetItem (by Name)

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



Top Method Summary
Options Name Purpose
Consultingwerk.OERA.NamedQueryParameterList Add (character, character) Adds a Character parameter to the list
Consultingwerk.OERA.NamedQueryParameterList Add (character, date) Adds a Date parameter to the list
Consultingwerk.OERA.NamedQueryParameterList Add (character, datetime) Adds a DateTime parameter to the list
Consultingwerk.OERA.NamedQueryParameterList Add (character, datetime-tz) Adds a DateTime-TZ parameter to the list
Consultingwerk.OERA.NamedQueryParameterList Add (character, decimal) Adds a Decimal parameter to the list
Consultingwerk.OERA.NamedQueryParameterList Add (character, int64) Adds an Int64 parameter to the list
Consultingwerk.OERA.NamedQueryParameterList Add (character, integer) Adds an Integer parameter to the list
Consultingwerk.OERA.NamedQueryParameterList Add (character, logical) Adds a Logical parameter to the list
Consultingwerk.OERA.NamedQueryParameterList Add (character, Object) Adds an Object parameter to the list
Consultingwerk.OERA.NamedQueryParameterEntry Add (NamedQueryParameterEntry) Adds an item to the generic List
Add (NamedQueryParameterEntry[]) Adds an array of items to the generic List
Consultingwerk.OERA.NamedQueryParameterEntry AddWhenNotContained (NamedQueryParameterEntry) Adds an item to the generic List only when it is not yet contained - silently ignores keys that are already contained
LOGICAL ContainsKey (character) Determines if an item with the specified key is contained in the List
CHARACTER GetCharacterValue (character) Retrieves a character value from the list
DATETIME-TZ GetDateTimeTzValue (character) Retrieves a datetime-tz value from the list
DATETIME GetDateTimeValue (character) Retrieves a datetime value from the list
DATE GetDateValue (character) Retrieves a date value from the list
DECIMAL GetDecimalValue (character) Retrieves a decimal value from the list
INT64 GetInt64Value (character) Retrieves a int64 value from the list
INTEGER GetIntegerValue (character) Retrieves a integer value from the list
Progress.Lang.Object GetItem (character) Retrieves the value of an item from the list
Consultingwerk.OERA.NamedQueryParameterEntry GetItem (integer) Retrieves an item from the generic List
LOGICAL GetLogicalValue (character) Retrieves a logical value from the list
CHARACTER GetParameterValueAsCharacter (character) Retrieves the value of an item from the list
DATE GetParameterValueAsDate (character) Retrieves the value of an item from the list
DATETIME GetParameterValueAsDateTime (character) Retrieves the value of an item from the list
DATETIME-TZ GetParameterValueAsDateTimeTz (character) Retrieves the value of an item from the list
DECIMAL GetParameterValueAsDecimal (character) Retrieves the value of an item from the list
INT64 GetParameterValueAsInt64 (character) Retrieves the value of an item from the list
INTEGER GetParameterValueAsInteger (character) Retrieves the value of an item from the list
LOGICAL GetParameterValueAsLogical (character) Retrieves the value of an item from the list
LOGICAL IsEmpty () Returns if the List is empty
Consultingwerk.OERA.NamedQueryParameterEntry Replace (NamedQueryParameterEntry, NamedQueryParameterEntry) Replaces an item in the generic List
Consultingwerk.OERA.NamedQueryParameterEntry ToArray () Returns an Array with the elements of the List


Method Detail
Top

Consultingwerk.OERA.NamedQueryParameterList Add (character, character)
Purpose: Adds a Character parameter to the list
Notes:

Parameters:
pcName CHARACTER
The name for the parameter
pcValue CHARACTER
The value for the parameter
Returns Consultingwerk.OERA.NamedQueryParameterList
The list itself (for fluent style coding)
Top

Consultingwerk.OERA.NamedQueryParameterList Add (character, date)
Purpose: Adds a Date parameter to the list
Notes:

Parameters:
pcName CHARACTER
The name for the parameter
pdtValue DATE
The value for the parameter
Returns Consultingwerk.OERA.NamedQueryParameterList
The list itself (for fluent style coding)
Top

Consultingwerk.OERA.NamedQueryParameterList Add (character, datetime)
Purpose: Adds a DateTime parameter to the list
Notes:

Parameters:
pcName CHARACTER
The name for the parameter
pdtValue DATETIME
The value for the parameter
Returns Consultingwerk.OERA.NamedQueryParameterList
The list itself (for fluent style coding)
Top

Consultingwerk.OERA.NamedQueryParameterList Add (character, datetime-tz)
Purpose: Adds a DateTime-TZ parameter to the list
Notes:

Parameters:
pcName CHARACTER
The name for the parameter
pdtValue DATETIME-TZ
The value for the parameter
Returns Consultingwerk.OERA.NamedQueryParameterList
The list itself (for fluent style coding)
Top

Consultingwerk.OERA.NamedQueryParameterList Add (character, decimal)
Purpose: Adds a Decimal parameter to the list
Notes:

Parameters:
pcName CHARACTER
The name for the parameter
pdeValue DECIMAL
The value for the parameter
Returns Consultingwerk.OERA.NamedQueryParameterList
The list itself (for fluent style coding)
Top

Consultingwerk.OERA.NamedQueryParameterList Add (character, int64)
Purpose: Adds an Int64 parameter to the list
Notes:

Parameters:
pcName CHARACTER
The name for the parameter
piValue INT64
The value for the parameter
Returns Consultingwerk.OERA.NamedQueryParameterList
The list itself (for fluent style coding)
Top

Consultingwerk.OERA.NamedQueryParameterList Add (character, integer)
Purpose: Adds an Integer parameter to the list
Notes:

Parameters:
pcName CHARACTER
The name for the parameter
piValue INTEGER
The value for the parameter
Returns Consultingwerk.OERA.NamedQueryParameterList
The list itself (for fluent style coding)
Top

Consultingwerk.OERA.NamedQueryParameterList Add (character, logical)
Purpose: Adds a Logical parameter to the list
Notes:

Parameters:
pcName CHARACTER
The name for the parameter
plValue LOGICAL
The value for the parameter
Returns Consultingwerk.OERA.NamedQueryParameterList
The list itself (for fluent style coding)
Top

Consultingwerk.OERA.NamedQueryParameterList Add (character, Object)
Purpose: Adds an Object parameter to the list
Notes:

Parameters:
pcName CHARACTER
The name for the parameter
poValue Progress.Lang.Object
The value for the parameter
Returns Consultingwerk.OERA.NamedQueryParameterList
The list itself (for fluent style coding)
Top

Consultingwerk.OERA.NamedQueryParameterEntry Add (NamedQueryParameterEntry)
Purpose: Adds an item to the generic List
Notes:

Parameters:
poItem Consultingwerk.OERA.NamedQueryParameterEntry
And item of the Lists member type
Returns Consultingwerk.OERA.NamedQueryParameterEntry
The new Item added to the List
Top

Add (NamedQueryParameterEntry[])
Purpose: Adds an array of items to the generic List
Notes:

Parameters:
poItem Consultingwerk.OERA.NamedQueryParameterEntry
An array of items of the Lists member type
Top

Consultingwerk.OERA.NamedQueryParameterEntry AddWhenNotContained (NamedQueryParameterEntry)
Purpose: Adds an item to the generic List only when it is not
yet contained - silently ignores keys that are already
contained
Notes:

Parameters:
poItem Consultingwerk.OERA.NamedQueryParameterEntry
And item of the Lists member type
Returns Consultingwerk.OERA.NamedQueryParameterEntry
The new Item added to the List
Top

LOGICAL ContainsKey (character)
Purpose: Determines if an item with the specified key is contained in the List
Notes:

Parameters:
pcKey CHARACTER
The key to locate in the Dictionary
Returns LOGICAL
Logical value indicating if the object is contained in the Dictionary
Top

CHARACTER GetCharacterValue (character)
Purpose: Retrieves a character value from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns CHARACTER
The character value
Top

DATETIME-TZ GetDateTimeTzValue (character)
Purpose: Retrieves a datetime-tz value from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns DATETIME-TZ
The datetime-tz value
Top

DATETIME GetDateTimeValue (character)
Purpose: Retrieves a datetime value from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns DATETIME
The datetime value
Top

DATE GetDateValue (character)
Purpose: Retrieves a date value from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns DATE
The date value
Top

DECIMAL GetDecimalValue (character)
Purpose: Retrieves a decimal value from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns DECIMAL
The decimal value
Top

INT64 GetInt64Value (character)
Purpose: Retrieves a int64 value from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns INT64
The int64 value
Top

INTEGER GetIntegerValue (character)
Purpose: Retrieves a integer value from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns INTEGER
The integer value
Top

Progress.Lang.Object GetItem (character)
Purpose: Retrieves the value of an item from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns Progress.Lang.Object
The value instance of the item with the specified key
Top

Consultingwerk.OERA.NamedQueryParameterEntry GetItem (integer)
Purpose: Retrieves an item from the generic List
Notes:

Parameters:
piIndex INTEGER
The 1 based index of the item to retrieve
Returns Consultingwerk.OERA.NamedQueryParameterEntry
The item of the Lists member type
Top

LOGICAL GetLogicalValue (character)
Purpose: Retrieves a logical value from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns LOGICAL
The logical value
Top

CHARACTER GetParameterValueAsCharacter (character)
Purpose: Retrieves the value of an item from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns CHARACTER
The character value of the item with the specified key
Top

DATE GetParameterValueAsDate (character)
Purpose: Retrieves the value of an item from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns DATE
The date value instance of the item with the specified key
Top

DATETIME GetParameterValueAsDateTime (character)
Purpose: Retrieves the value of an item from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns DATETIME
The datetime value instance of the item with the specified key
Top

DATETIME-TZ GetParameterValueAsDateTimeTz (character)
Purpose: Retrieves the value of an item from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns DATETIME-TZ
The datetime-tz value instance of the item with the specified key
Top

DECIMAL GetParameterValueAsDecimal (character)
Purpose: Retrieves the value of an item from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns DECIMAL
The decimal value instance of the item with the specified key
Top

INT64 GetParameterValueAsInt64 (character)
Purpose: Retrieves the value of an item from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns INT64
The int64 value instance of the item with the specified key
Top

INTEGER GetParameterValueAsInteger (character)
Purpose: Retrieves the value of an item from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns INTEGER
The integer value instance of the item with the specified key
Top

LOGICAL GetParameterValueAsLogical (character)
Purpose: Retrieves the value of an item from the list
Notes:

Parameters:
pcKey CHARACTER
The key of the item to retrieve
Returns LOGICAL
The logical value instance of the item with the specified key
Top

LOGICAL IsEmpty ()
Purpose: Returns if the List is empty
Notes:

Returns LOGICAL
Logical value indicating if the list if empty
Top

Consultingwerk.OERA.NamedQueryParameterEntry Replace (NamedQueryParameterEntry, NamedQueryParameterEntry)
Purpose: Replaces an item in the generic List
Notes:

Parameters:
poExistingItem Consultingwerk.OERA.NamedQueryParameterEntry
The item to replace
poNewItem Consultingwerk.OERA.NamedQueryParameterEntry
The new item
Returns Consultingwerk.OERA.NamedQueryParameterEntry
The reference to the replaced item
Top

Consultingwerk.OERA.NamedQueryParameterEntry ToArray ()
Purpose: Returns an Array with the elements of the List
Notes:

Returns Consultingwerk.OERA.NamedQueryParameterEntry
The array of elements of the Lists member type


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