Citect SCADA 8.1 - How to log data into SQL DB table by trigger

Join Date
Mar 2015
Location
Mariupol, Ukraine
Posts
71
Hello all!
I am new in Citect SCADA. I need to create material tracking system in which I have a dozen of photometric sensors. When each sensor catchs the material presense I need to write date and time value item in the SQL DB table. The table fields could be for example the following:
Piece ID - Numeric
Sensor 1 - DateTime
Sensor 2 - DateTime
.....
Sensor 10 - DateTime

I have read a lot of information on this forum and on other resourses. How to write data into SQL table from Cicode function is more or less clear for me. But I still can't figure out how I can create a trigger for this.
Could you please give me any advice how can I solve this problem?

Best regards, Oleksandr.
 
This might be a bit too late, but you can create an event with your sensors as the trigger and call the function you wrote in cicode for logging the data.
 

Similar Topics

Hi Guys, Hope someone can help with this. I am trying to log variable changes to a text file using the Log device in citect Scada 7.4x My Log...
Replies
4
Views
3,895
Our system have 2 HMI using citect scada v 7.1 . one installed as a Remote station. in the Remote station the event alarm time different with PC...
Replies
0
Views
3,585
I am trying to display a variable within a cicode function onto a graphics page. This function queries a SQL database. I can get the value onto a...
Replies
3
Views
274
We are trying to set up a newer generation Omron PLC (NX/NS Series) with Citect / Aveva Plant SCADA using the Ethernet/IP CIP Protocol to read...
Replies
2
Views
345
I am new to Citect SCADA and I am building the graphics for a page that will contain the control of a plant by a Kingfisher RTU. The project I...
Replies
0
Views
250
Back
Top Bottom