Zeal

Thank you for the response.

So, After giving the channels of each PLC a different Timing/Offset combination will solve the issue of lagging of data if any one more  PLC is not powered up?. 

I will share the document for sure by the end of week.

Hello Sir/Madam,

The SCADA project has 4 PLC's  connected on Modbus TCP communication protocol. However, if any device is switched off the project file runs too slow. Is there a need that all 4 devices must be power on. Is there any suggestion that if no device is connected or any one or more device are  connected the SCADA doesn't run slow. A trial of device bypass using sequence has not much success as the project file is closed on its own without any error. Is it possible that there is a log of the file being shutdown?.

Thank you.

Are there any suggestion through which the excel macro could be operated without opening excel. If so, that would be of wonderful help.

Is there any suggestion for things mentioned in the reply?, by which the excel we could run the excel macro from Daq Factory itself. If there is way it would be of much help.

Yes the name of my sequence is S3. We will implement your suggestion and will inform about the result. I think this will surely work.

I am inserting data using below sequence. In this sequence Registry.strFileName[0] is my database path and name. The sequence runs fine and my data gets dump good. However after some time there is an error showing unable to connect database. After restarting the sequence manually same error prevails. 

But after restarting Daq Factory project the sequence starts working normally again and data inserting works ok.

while(1)
   if (AutoCycleRunning == 1)
      dbase = db.OpenEx("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Zeal\Hitachi\DB\"+Registry.strFileName[0]+".mdb;Uid=Admin;Pwd=;")
      db.Execute(dbase,"INSERT INTO Data_(A1,A2,A3,A4,A5,A6) values ('"+ FormatDateTime("%Y-%m-%d %H:%M:%S", SysTime()) +"','"+Angle_PV[0]/10+"','"+ Torque[0] +"','"+ DC_Current[0]/100 +"','"+ AC_Current[0]/100 +"','"+ PresentCount[0] +"')")
      db.Close(dbase)
   endif
 

   if (AutoCycleRunning == 0)
      delay(1)
      db.Close(dbase)
      endseq(S3)
   endif
   delay(0.01)
endwhile
   

Generally there is a preference to run the excel macro from the SCADA and also to write data to a specific cell of the excel,  where the excel has relevant features to align and use such feature. 

Thank you

Thank you.

The this is possible by changing the row number to as per requirement. Didn't know what row meant for.

Thank your

The now the X axis value is same,  lets say the channel name is time is same for  3 other variable which needs to be plotted along the Y axis. The value first variable is from 0-30 , second variable value ranges from 0-360 and the third variable value ranges from 0-1700. So, can there be a graph plotted whose Y axis value has of 3 different range of 3 variable . Firstly the value of Y axis starts from 0 -30 ,now above the 30 value there would be a value from 0-360 on the same Y axis with a new origin on the same line, say the same graph. Additionally, the Y axis of third variable from 0-1700 ,now the 0 of the third variable needs to be above the max value of variable two . There is an attached image file, however such a graph is not required. The requirement is on a single Y axis with values of Y axis of different variable one after another.

As per the given example of DDE on excel we are able to get data to excel. However, can we use different DDE function as attached. If it is possible to use  DDE function shown in the image attached; if yes how  to use them.

Firstly thank for the wonderful understandable response.

Secondly would be possible in "Lin" if my X axis comes from a timer from the PLC and would I be able to get milliseconds. In my case there are 3 variable to plotted in graph and to be shown for each cycle. Also, task being that X axis remains same however the Y axis varies so can there be a continuous Y axis from 0-10 for one variable ,0-1900 in the same Y-axis for second variable and 0-180 for the third variable.

I would like to create time base X-Axis, however the Time  doesn't need to be current time. It needs be cycle time say for eg 8 sec which I vary maximum to 1 sec in every cycle and I receive the value on a variable from my PLC. The major issue being I get too much data for that 8 sec. and the graph doesn't show that value, any suggestion for that.

Moreover how do I further increase enlarge to millisecond in the X-Axis. 

Also, how the example base scripting given doesn't show in the user guide. For eg the pdf based example on samples of pdf which was a shocker to me.

furtherly what coding base does the software use so can follow the same.

Appreciating the timely based response.

Thank you for the response, but I would like know the difference between  both the query.

And what exactly is the usage of db.queryToclass().

Also can I know the status of database(like open,close).

what is the usage of tree list?.

Is there an example of the trees list properties usage?

Can i rename the tree names of parent and child.

Please do share if there is any sample program.

I AM USING AZEOTECH SCADA V16.3.

I AM CONNECTING 4 NOS OF PLCS. WHILE I AM NOT CONNECTED WITH ANYONE PLC THE SCADA SOFTWARE IS HANGGING TOO MUCH.

SO THAT I HAVE WRITTEN THE BELOW SCRIPT.

   while(1)
   if (device.PLC1.Connected)
      device.plc1.ClearBypass()
   else
      device.plc1.SetBypass()
   endif
      
   if (device.plc2.Connected)
      device.plc2.ClearBypass()
   else
      device.plc2.SetBypass()
   endif
 
   if (device.plc3.Connected)
      device.plc3.ClearBypass()
   else
      device.plc3.SetBypass()
   endif
   
   if (device.plc4.Connected)
      device.plc4.ClearBypass()
   else
      device.plc4.SetBypass()
   endif

  endwhile

THE ABOVE SCRIPT IS ON AUTO START MODE. 

ISSUE IS WHEN I AM DISCONNECTING THE NO.1 PLC(PLC1) THE SCADA APP CRASHES AFTER 20-30SECONDS. AND THE ERROR CODE IS AS BELOW.

RESOLUTION NEDDED IS:-

IF I WANT TO CONNECT 4 PLCS THEN WHAT IS THE CODE I HAVE TO PUT.(WHICH WILL NOT CAUSE SCADA HANGGING ISSUE OR APP CRASH.)

I have a database and i am able to read write the data in tables of database.

Now i want all tables name in DAQFactory.

so, how to get table name in String Channel using sql query?

Following query i try but not work

qr = db.Query(dbase,"SELECT name FROM sys.Tables")