Promotic

Parameters for type: FireBird database - configuration window

Description:
The window serves for setting the parameters for the data storage into the FireBird database.
This type of saving is suitable especially for local alarm group (server) where the alarm group represents a place in the application where the alarm items really originate and are stored to the database for viewing purposes. The window serves for setting the parameters for database connection and also for setup of the database table parameters (e.g. the maximum table size). Each time the maximum number of records in the database table is exceeded the oldest records are automatically deleted.
In the case of a remote alarm group (see the "Remote group (client)" configurator), it sets the way of getting the data for the alarm history viewer by file sharing . The current alarm states is not transferred by this way. The alarm states have to be transferred somehow between groups and to set the states by a script. The simplest way, in this case, is to use the data sharing of an alarm group by means of the "Remote connection via the Web" configurator where both the alarm state viewer (including the alarm acknowledgment) and the alarm history viewer are active.
Configurators:
Data source (ConnectionString)The ADO ConnectionString (http://www.connectionstrings.com) contains all necessary parameters needed by the ADO Connection object for database connection via the selected ADO Provider.
Macro expression can be used for input (it is evaluated after the application is launched). This configurator must not contain an empty string. For example "PROVIDER=MSDASQL;DRIVER={Firebird/InterBase(r) driver};SERVER=localhost;DATABASE=localhost:pm_data;UID=pm_writer;PWD=pmwriter;"
Additional parametersAdditional parameters for saving. Entries are in the KeyVal format, for example "par1:value1;".
Macro expression can be used for input (it is evaluated after the application is launched).
TableName of the database table into which the data are stored.
Macro expression can be used for input (it is evaluated after the application is launched).
Maximum number of records (-1 = unlimited)Maximum size of the table specified by the records count. When the maximum limit is exceeded the oldest records are deleted.
The -1 value means that the maximum size of the table is not limited by the records count.

History:
Pm9.00.00: Created
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.