Topics

1

Support Questions / Simple BasicDataLogger2 Question

« on: March 02, 2018, 09:32:14 AM »

I am trying to use the BasicDataLogger2 and the only issue i'm having is that i would like to log the data when "WriteOnBitTrue", but where do i define that bit?

Is it in the properties of the BasicDataLogger2 or do i define it somewhere in the form coding?

Thanks!

2

Support Questions / Heartbeat Signal

« on: February 09, 2018, 11:11:08 AM »

I was hoping for some direction on how to make a heartbeat signal between the AdvancedHMI program i have running and a compact logix L18ER processor over ethernet.

I do not want the PLC to be able to run the equipment without communication established.

Thanks!

3

Open Discussion / Reading Data from SQL

« on: November 20, 2017, 10:43:33 AM »

Guys,

Now that I have been having great success using DataSubscribers, i would like to see if there is an easy way to check what info is in the latest row of the database. Or what is the best way for me to make sure that the data i sent to the Database did indeed make it there.

Thanks!

4

Support Questions / Using multiple DataSubscribers

« on: November 09, 2017, 09:07:30 AM »

I am trying to use multiple DataSubscribers to write to an SQL database. The issue i am having is each one of my DataSubscribers are making a new row instead of writing data to the same row after the first one makes a new row. I'm not sure how to program this logic in .vb.

Here is the code i have:

Code: [Select]

    Private Sub DataSubscriber1_DataChanged(sender As Object, e As Drivers.Common.PlcComEventArgs) Handles DataSubscriber1.DataChanged
        Using t As New ControlsDBDataSet1.StoreData2DataTable
            t.AddStoreData2Row(t.NewRow)
            t(0).Data = e.Values(0)

            Using ta As New ControlsDBDataSet1TableAdapters.StoreData2TableAdapter
                ta.Update(t)

            End Using
        End Using
    End Sub

    Private Sub DataSubscriber2_DataChanged(sender As Object, e As Drivers.Common.PlcComEventArgs) Handles DataSubscriber2.DataChanged
        Using t As New ControlsDBDataSet1.StoreData2DataTable
            t.AddStoreData2Row(t.NewRow)
            t(0).State = e.Values(0)

            Using ta As New ControlsDBDataSet1TableAdapters.StoreData2TableAdapter
                ta.Update(t)

            End Using
        End Using
    End Sub

    Private Sub DataSubscriber3_DataChanged(sender As Object, e As Drivers.Common.PlcComEventArgs) Handles DataSubscriber3.DataChanged
        Using t As New ControlsDBDataSet1.StoreData2DataTable
            t.AddStoreData2Row(t.NewRow)
            t(0).Green = e.Values(0)

            Using ta As New ControlsDBDataSet1TableAdapters.StoreData2TableAdapter
                ta.Update(t)
            End Using
        End Using
    End Sub
I'm sure this is a simple fix.

Thanks