File Name
Syntax
DeleteConnectionTypeRec( VAL InTran: BOOLEAN, REF DeleteRec: ConnectionTypeRec )
Parameters
InTran - in a transaction or not
DeleteRec - connection type record to be deleted
Returns
SQL return result
Side Effects
None
Description
This function deletes a record from the connection type table.
Dialog Forms Called
None
File Name
Syntax
DeleteParamValuePreferencesRec( VAL InTran: BOOLEAN, REF DeleteRec: I_PreferencesRec )
Parameters
InTran - in a transaction or not
DeleteRec - i_preferences record to be deleted
Returns
SQL return result
Side Effects
None
Description
This function deletes rows in the i_preferences table by preference_id, parameter name, and parameter value.
Dialog Forms Called
None
File Name
Syntax
DeletePreferencesRec( VAL InTran: BOOLEAN, REF preference_id: INTEGER )
Parameters
InTran - in a transaction or not
preference_id - preference ID
Returns
SQL return result
Side Effects
None
Description
This function deletes a record from the i_preferences table.
Dialog Forms Called
None
File Name
Syntax
DuplicatePreferenceName(VAL preference_name: STRING, VAL preference_id: INTEGER)
Parameters
preference_name - preference name
preference_id - preference ID
Returns
Boolean - TRUE if duplicate preference name; FALSE if original preference name
Side Effects
None
Description
This function checks to see if the preference name already exists in the table.
Dialog Forms Called
None
File Name
Syntax
GetConnectionTypeList( REF ktypeList: LIST OF ConnectionTypeRec, REF c_typeNameList: LIST OF STRING )
Parameters
ktypeList - list of connection type records
c_typeNameList - list of connection type names
Returns
SQL return result
Side Effects
None
Description
This function returns a list of connection type names.
Dialog Forms Called
None
File Name
Syntax
GetDataSourcesByPref( VAL preference_id: INTEGER, VAL paramname: STRING, REF dataSources: LIST OF STRING)
Parameters
preference_id - preference ID
paramname - paramname
dataSources - list of data sources
Returns
SQL return result
Side Effects
None
Description
This function returns a list of data sources based on the preference ID supplied.
Dialog Forms Called
None
File Name
Syntax
GetPreferences( VAL preference_id: Integer, REF cfg: ICfgPreferenceRecord )
Parameters
preference_id - preference ID
cfg - preference configuration record
Returns
SQL return result
Side Effects
None
Description
This function returns a preference configuration record.
Dialog Forms Called
None
File Name
Syntax
InsertConnectionTypeRec( VAL InTran: BOOLEAN, REF InsertRec: ConnectionTypeRec )
Parameters
InTran - in a transaction or not
InsertRec - connection type record to be inserted
Returns
SQL return result
Side Effects
None
Description
This function inserts a new record into the connection type table.
Dialog Forms Called
None
File Name
Syntax
InsertParamValuePreferencesRec( VAL InTran: BOOLEAN, REF InsertRec: I_PreferencesRec )
Parameters
InTran - in a transaction or not
InsertRec - i_preferences record
Returns
SQL return result
Side Effects
None
Description
This function inserts a record into the i_preferences table.
Dialog Forms Called
None
File Name
Syntax
InsertPreferences( VAL InTran: BOOLEAN, REF InsertRec: ICfgPreferenceRecord )
Parameters
InTran - in a transaction or not
InsertRec - i_preferences record
Returns
SQL return result
Side Effects
None
Description
This function inserts a record into the i_preferences table.
Dialog Forms Called
None
File Name
Syntax
LoadAllPreferences
Parameters
None
Returns
preference list
Side Effects
None
Description
This function loads all the preferences for each ID.
Dialog Forms Called
None
File Name
Syntax
UpdateConnectionTypeRec( VAL InTran: BOOLEAN, REF BeforeRec: ConnectionTypeRec, REF AfterRec: ConnectionTypeRec )
Parameters
InTran - in a transaction or not
BeforeRec - original connection type record
AfterRec - new connection type record
Returns
SQL return result
Side Effects
None
Description
This function updates a record in the connection type table.
Dialog Forms Called
None
File Name
Syntax
UpdateListOfConnectionTypeRec( VAL InTran: BOOLEAN, REF BeforeList: LIST OF ConnectionTypeRec, REF AfterList: LIST OF ConnectionTypeRec )
Parameters
InTran - in a transaction or not
BeforeList - original list of connection type records
AfterList - new list of connection type records
Returns
SQL return result
Side Effects
None
Description
This function updates a list of connection type records.
Dialog Forms Called
None
File Name
Syntax
UpdateParamValue( VAL InTran: BOOLEAN, VAL paramname: STRING, VAL beforeparamvalue: STRING, VAL afterparamvalue: STRING, VAL preference_id: INTEGER )
Parameters
InTran - in a transaction or not
paramname - parameter name
beforeparamvalue - original parameter value
afterparamvalue - new parameter value
preference_id - preference ID
Returns
SQL return result
Side Effects
None
Description
This function updates rows in the i_preferences table by paramvalue.
Dialog Forms Called
None
File Name
Syntax
UpdateParamValuePreferencesRec( VAL InTran: BOOLEAN, REF BeforeRec: I_PreferencesRec, REF AfterRec: I_PreferencesRec )
Parameters
InTran - in a transaction or not
BeforeRec - original i_preferences record
AfterRec - new i_preferences record
Returns
SQL return result
Side Effects
None
Description
This function updates rows in the i_preferences table by preference ID, parameter name, and parameter value.
Dialog Forms Called
None
File Name
Syntax
UpdatePreferencesRec( VAL InTran: BOOLEAN, REF BeforeRec: ICfgPreferenceRecord, REF AfterRec: ICfgPreferenceRecord )
Parameters
InTran - in a transaction or not
BeforeRec - original preference configuration record
AfterRec - new preference configuration record
Returns
SQL return result
Side Effects
None
Description
This function updates rows in the i_preferences table by paramvalue.
Dialog Forms Called
None