UpdateCollect
- Last UpdatedNov 02, 2023
- 1 minute read
The function of this Business Logic Tier (BLT) is to modify collect data and re-summarize the affected day, month, and year. It can add, delete, or change the collect data that exists in the Historical database collect table. The procedure automatically re-summarizes the data for the Historical database hour, day, month, and year tables.
Syntax
UpdateCollect <pointName> <time> <milliSec> <value> <operType> [<fieldTime> <fieldMillisec>]
Parameters
|
Name |
Description |
|---|---|
|
pointName |
The name of the point to be modified. |
|
time |
The time of the affected collect data to be modified. This value is shown as 'YYYY-MM-DD hh:mm:ss' format (as per your computer’s Regional and Language settings). |
|
milliSec |
The field shows the millisecond value of the time field. |
|
value |
The new value of the point after modification or addition. This parameter is ignored during deletions. |
|
operType |
There are three potential actions: ADD, MOD, and DEL. |
|
fieldTime |
The new value of the field timestamp. This value is shown as 'YYYY-MM-DD hh:mm:ss' format (as per your computer’s Regional and Language settings). |
|
fieldMillisec |
The field shows the millisecond value of the fieldTime field. |
Example
UpdateCollect 'analog.03_billt.curval' '2014-06-01 13:45:05' 35 75.3 'ADD' '2014-06-01 13:45:18' 174
(1 row affected.)