Topics

1

Support Questions / Data Logging in database

« on: August 31, 2022, 10:19:09 AM »

I am using a datasubscriber (or at least I think I am)lol to capture values in an array and display them. I am currently using the PLC as my data logger with the array being 1000 in depth. I would like to start using a DB now that we have a server we can run the software on 24-7

Without rewriting my entire code how can I get the data to the database?

Public Class MainForm
    Private Sub DataSubscriber1_DataChanged(sender As Object, e As Drivers.Common.PlcComEventArgs) Handles DataSubscriber1.DataChanged
        BasicLabel1.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,23]")
        BasicLabel2.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,22]")
        BasicLabel3.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,21]")
        BasicLabel4.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,20]")
        BasicLabel5.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,19]")
        BasicLabel6.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,18]")
        BasicLabel7.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,17]")
        BasicLabel8.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,16]")
        BasicLabel9.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,15]")
        BasicLabel10.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,14]")
        BasicLabel11.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,13]")
        BasicLabel12.Text = EthernetIPforCLXCom1.Read("BH_Level_Below_Ground_History[1,12]")

     Thanks for the help, i am open to any of the DB software but the easiest would be best.

2

Support Questions / DateTimePicker or MonthCalendar to PLC Tag

« on: March 24, 2022, 02:26:10 PM »

Hey guys,

Wondering if anyone has implemented a MonthCalendar or a DateTimePicker in to a CLX project..

Want to figure out how I could get one of them to write to a tag in my PLC.

Thanks

3

Support Questions / MS SQL database Questions, I'm completely new to VB

« on: March 15, 2022, 11:06:53 AM »

Hello team,   
Love the project and am having a blast with it..

I have created a display with some live data in fields and a couple trending tables, all live..

I am wanting to get 4 bits logged in to a MS SQL server every hour. I have followed a video I found on YouTube and am able to log 1 tag from the PLC every 5 seconds no problem but I need every hour witch I think can do with a GSV and trigger bit from my CLX plc, I have now added more columns to my DB and need to get data to them. Would I need to do multiple datasubscribers or can it all be completed in 1?
Can someone please help with the code?