Hi Guys

We made an VB-Code to write some values to the SQL server which is working correctly when we call it from a normal button click

However,  when we make the cyclic /trigger every 5 minutes its not working and showing alarms

Could anyone please check the attached VB-code and the alarm we receive 

-Operating System: Windows 10

- The desired application : Water treatment

- 

Hi,

May I suggest that you change your "HMIRuntime.Trace" output to say:

"SQL Writing Error A: "....
and

"SQL Writing Error B: "....
etc.

so you can tell where in the script you get errors.

Also, before:

TagVal(i) = SmartTags(TagList(i))
If err.number <>0 Then

Add the line:

err.clear
TagVal(i) = SmartTags(TagList(i))
If err.number <>0 Then