SettingsTools Class

Global variables/functions for settings access

Inheritance Hierarchy

Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)

Syntax

public sealed class SettingsTools

The SettingsTools type exposes the following members.

Methods

NameSummary
public methodenv(Boolean)
environment for settings (+1 of selected Environment which is the index of the dropdown, if baseZero is set then simply the index)
public methodfetchSetting(String, String)
encapsulates setting fetching (currently ConfigurationManager from DBAddin.xll.config), use only for strings. For Integer and Boolean use fetchSettingInt and fetchSettingBool
public methodfetchSettingBool(String, String)
exception proof fetching of boolean settings
public methodfetchSettingInt(String, String)
exception proof fetching of integer settings
public methodinitSettings()
initializes global configuration variables
public methodsetUserSetting(String, String)
change or add a key/value pair in the user settings

Fields

NameDescription
public fieldCmdTimeout
global command timeout (can't be set in DB functions)
public fieldCnnTimeout
global connection timeout (can't be set in DB functions)
public fieldConstConnString
Default ConnectionString, if no connection string is given by user....
public fieldDefaultDBDateFormatting
default formatting style used in DBDate
public fielddeleteRowKey
the configurable shortcut for the delete row key (default ^D)
public fieldenvirondefs
environment definitions
public fieldinsertRowKey
the configurable shortcut for the insert row key (default ^I)
public fieldjumpButtonKey
the configurable shortcut for the jump button key (default ^J)
public fieldrefreshDataKey
the configurable shortcut for the refresh data key (default ^R)
public fieldselectedEnvironment
currently selected environment for DB Functions, zero based (env -1) !!
private fieldUserSettingsPath
The path where the User specific settings (overrides of standard/global settings) can be found (hard-coded to path of xll)