1
Support Questions / BasicDataLogger2 sql database
« on: August 22, 2017, 07:10:39 PM »
Using BasicDataLogger2 I'm inserting a row in MySql. I wish each PLC value that's in the PLCAddressValueItems would be inserted into one row. The issue is that each row contains one PLC value that alternates between the three values.
Can I make BasicDataLogger2 insert multiple columns into sql?
The three PLC value's are (Value1, Value2, and Value3) and the three MySql columns are (c1, c2, and c3).
Here is the code I'm using:
Private Sub BasicDataLogger21_DataReturned(sender As Object, e As Drivers.Common.PlcComEventArgs) Handles BasicDataLogger21.DataReturned
Using t As New DataSet.logDataTable
t.AddlogRow(t.NewRow)
t(0).c1 = e.Values(0)
Using ta As New DataSetTableAdapters.logTableAdapter
ta.Update(t)
End Using
End Using
End Sub
I'm using Windows 10 Pro, Visual Studio 15.3.2, and AdvancedHMI v399x.
Thanks!
Can I make BasicDataLogger2 insert multiple columns into sql?
The three PLC value's are (Value1, Value2, and Value3) and the three MySql columns are (c1, c2, and c3).
Here is the code I'm using:
Private Sub BasicDataLogger21_DataReturned(sender As Object, e As Drivers.Common.PlcComEventArgs) Handles BasicDataLogger21.DataReturned
Using t As New DataSet.logDataTable
t.AddlogRow(t.NewRow)
t(0).c1 = e.Values(0)
Using ta As New DataSetTableAdapters.logTableAdapter
ta.Update(t)
End Using
End Using
End Sub
I'm using Windows 10 Pro, Visual Studio 15.3.2, and AdvancedHMI v399x.
Thanks!