DB_ENABLE_MSEC
About this task
For | Database Logger System or Project | |
Purpose | To create a separate column in which the CIMPLICITY Data Logger will store the sub-second portion of the timestamps to the nearest millisecond. This capability can be important when a database is not capable of storing time values with a timestamp accuracy of 1/1000 of a second, which is the accuracy that CIMPLICITY Data Logger achieves. In fact, most databases can only handle storing time values to the nearest second. Therefore when timestamps are inserted into the database, their values are either truncated or rounded, by the database, to a value that complies with the database's storage capabilities. You can create DB_ENABLE_MSEC in either the Project or the System folder. The result is as follows: | |
Folder | Global Parameter will be used by: | |
System | Millisecond Logging compatible clients whom are started outside the scope of the project environment and copied into all new CIMPLICITY projects that you create (e.g. Starting a CimView screen outside of a project). | |
Project | Only the project's logging processes and Millisecond Logging compatible clients started within the context of the project environment. | |
Value | Values include: | |
Y | Creates a separate column. | |
N | Does not create a separate column. | |
Default Value |
msec
is the default name of a field that
CIMPLICITY creates in the database.
Note: CIMPLICITY names the field msec. To change this name, use the global parameter DB_MSEC_FIELD.
|
Important: