Hi. I have followed your steps but I have a problem when I compile. It says Error FUNCTION expected. It happens both in the RANDOM button and in the INSERT button. Any idea? Thanks!
Random function need to be created. Here is the cicode INT FUNCTION Randm() TAG1 = Rand(101); TAG2 = Rand(10); TAG3 = Rand(50); TAG4 = Rand(60); TAG5 = Rand(20); RETURN 0; END For Insert button , make sure you define same function in button that you have created in cicode.
@@StableAutomation Thanks for your answer. Now I can compile without problems and generate the random numbers, however when I click on insert button the data is not inserted into the datatable...I don´t know what I am missing.
This is a great video that helps me on my project. However, i would like to know how can I log the data every hour automatically without manually clicking the insert button. Hope you can help. Thanks!
@@StableAutomation i have created an event which started at 09:00:00 with period of 5 minutes, Action = SQL_INSERT(), is it correct for me to do in this way? I did it this way however the data isn't logging. Please advise. Thanks.
how to sql data log on one computer to another computer (Main Server & Standby )in citech sacda...any coding is there?
I increased string size but only holding 40 value how to configure for until it gets full
Hi. I have followed your steps but I have a problem when I compile. It says Error FUNCTION expected. It happens both in the RANDOM button and in the INSERT button. Any idea? Thanks!
Random function need to be created. Here is the cicode
INT
FUNCTION
Randm()
TAG1 = Rand(101);
TAG2 = Rand(10);
TAG3 = Rand(50);
TAG4 = Rand(60);
TAG5 = Rand(20);
RETURN 0;
END
For Insert button , make sure you define same function in button that you have created in cicode.
@@StableAutomation Thanks for your answer. Now I can compile without problems and generate the random numbers, however when I click on insert button the data is not inserted into the datatable...I don´t know what I am missing.
try to debug your code. check this to know how to debug : ruclips.net/video/Mqofftll71E/видео.html
Excellent..thanks !!
How to use cicode to retrieve the data from a SQL Database (Just Reading)?
But in sql table timeanddate column shows NULL..can you please help
How to add date and time data to sql? I've tried to use command timecurrent, but data stucks in 1900-01-01 00:00:00 (sql)
Just add column in SQL with datatype datetime and default value not null
This is a great video that helps me on my project. However, i would like to know how can I log the data every hour automatically without manually clicking the insert button. Hope you can help. Thanks!
Create event to trigger your code every hour
@@StableAutomation i have created an event which started at 09:00:00 with period of 5 minutes, Action = SQL_INSERT(), is it correct for me to do in this way?
I did it this way however the data isn't logging. Please advise. Thanks.
settings are ok. i would suggest to use 00:00:00 as start time. you also need to enable event from computer setup wizard.
@@StableAutomation Thanks for your help, the problem is solved after enable event in computer setup wizard.
@@laikianhong5946 that's great.
Can you do a tutorial about citect SCADA
Definately... In next few videos I will be covering siemens LOGO plc. Then I will start making videos on Citect. Stay tuned.
@@StableAutomation thank you so much ,I'm waiting for the Citect SCADA course