Routines for i_cfg_db.kb


DeleteConnectionTypeRec

File Name

i_cfg_db.kb

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


DeleteParamValuePreferencesRec

File Name

i_cfg_db.kb

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


DeletePreferencesRec

File Name

i_cfg_db.kb

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


DuplicatePreferenceName

File Name

i_cfg_db.kb

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


GetConnectionTypeList

File Name

i_cfg_db.kb

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


GetDataSourcesByPref

File Name

i_cfg_db.kb

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


GetPreferences

File Name

i_cfg_db.kb

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


InsertConnectionTypeRec

File Name

i_cfg_db.kb

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


InsertParamValuePreferencesRec

File Name

i_cfg_db.kb

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


InsertPreferences

File Name

i_cfg_db.kb

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


LoadAllPreferences

File Name

i_cfg_db.kb

Syntax

LoadAllPreferences

Parameters

None

Returns

preference list

Side Effects

None

Description

This function loads all the preferences for each ID.

Dialog Forms Called

None


UpdateConnectionTypeRec

File Name

i_cfg_db.kb

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


UpdateListOfConnectionTypeRec

File Name

i_cfg_db.kb

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


UpdateParamValue

File Name

i_cfg_db.kb

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


UpdateParamValuePreferencesRec

File Name

i_cfg_db.kb

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


UpdatePreferencesRec

File Name

i_cfg_db.kb

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