By the RunTime method it is possible to do backward writing for this type of setting the storage (it is possible to write the records with the older time than the time of the last written record).
Caution: Two different PmaTrendGroup objects cannot be set so that they store the data into one *.mdb file.
The variable name on the "Data" tab can be maximum 64 characters long (the length of column name in the Access table is limited).
This storage type has a limitation: If there are multiple PmaTrendGroup objects used with this storage type in the application, then there can be 63 such objects in one application at the most.| 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 starting the application). This configurator must not contain an empty string.For example $.join("Provider=Microsoft.Jet.OLEDB.4.0;","Data Source=",$.path("data","trend/"),$.expr("pMe.GroupId"),".mdb;") |
|---|---|
| Additional parameters | Additional parameters for saving. Allows to define names and data types of system columns, database types based on the trended value data type. Available parameters are shown in the following example together with their preset values for selectaed saving type (plugin). These values may not be entered. Enter the values only if non-default are needed. Entries are in KeyVal format, for example "coltimename:pm_time;colattrname:pm_attr;dbdt.pmtime:DATETIME;dbdt.pmattr:LONG;dbdt.f64:DOUBLE;dbdt.f32:SINGLE;dbdt.i32:LONG;dbdt.i16:SHORT;dbdt.u8:BYTE;dbdt.b:BIT;". Macro expression can be used for input (it is evaluated after starting the application). coltimename (optional) - Name of column containing the record timestamp.(default) "coltimename:pm_time;". colattrname (optional) - Name of column containing the record attribute.(default) "colattrname:pm_attr;". dbdt.pmtime (optional) - Database data type of the column containing record timestamp.(default) "dbdt.pmtime:DATETIME;". dbdt.pmattr (optional) - Database data type of the column containing record attribute.(default) "dbdt.pmattr:LONG;". dbdt.f64 (optional) - Database data type of the column for trended variable of data type: Float64 (Double). This is used if the trended value does not have its database data type defined.(default) "dbdt.f64:DOUBLE;". dbdt.f32 (optional) - Database data type of the column for trended variable of data type: Float32 (Single). This is used if the trended value does not have its database data type defined.(default) "dbdt.f32:SINGLE;". dbdt.i32 (optional) - Database data type of the column for trended variable of data type: Int32 (Long). This is used if the trended value does not have its database data type defined.(default) "dbdt.i32:LONG;". dbdt.i16 (optional) - Database data type of the column for trended variable of data type: Int16 (Integer). This is used if the trended value does not have its database data type defined.(default) "dbdt.i16:SHORT;". dbdt.u8 (optional) - Database data type of the column for trended variable of data type: Uint8 (Byte). This is used if the trended value does not have its database data type defined.(default) "dbdt.u8:BYTE;". dbdt.b (optional) - Database data type of the column for trended variable of data type: Bool (Boolean). This is used if the trended value does not have its database data type defined.(default) "dbdt.b:BIT;". |
| Table | Name of the table in the database into which the data are stored. Macro expression can be used for input (it is evaluated after starting the application). This configurator must not contain an empty string. |
| Minimum table size | Minimum size of the table specified by the records count. The number of records in the table never drops below this minimum limit. |
| Maximum table size | Maximum size of the table specified by the records count. The number of records in the table never exceeds this maximum limit. When exceeding this limit, such count of the oldest records is removed to decrease the records count in the table to the minimum size of the table. The value -1 means that the maximum size of the table is not limited by the records count. |
| Minimum table size by time interval | Minimum size of the table specified by the time interval. The time size of table records never drops below this minimum limit. |
| Maximum table size by time interval | Maximum size of the table specified by the time range. The maximum time-range of all records in the table. When exceeding this limit, such count of the oldest records is removed to decrease the records count in the table to the minimum size of the table. The value -1 means that the maximum size of the table is not limited by the time size. |