Sub SQL_Write_AMT
If SQL1.IsInitialized = False Then 'in case the connection closes
SQL1.Initialize2("com.mysql.jdbc.Driver", "jdbc:mysql://mywebsite/site", "user", "password")
End If
Try
For i = 0 To AMT_Size-1 '199
SQL1.AddNonQueryToBatch("INSERT IGNORE INTO " & table_name & " VALUES (?,?,?,?,?,?,?,?,?,?,?,?)", Array As Object(AMT_Trade_ID(i), AMT_Date_Time(i), AMT_CoinPair(i), _
AMT_Pri_Coin(i), AMT_Sec_Coin(i), AMT_MarketID(i), AMT_Trade_Type(i), AMT_Trade_Price(i), AMT_Quantity(i), AMT_Total(i) _
, Price_Deviation(AMT_MarketID(i)), Loss_Coin(AMT_MarketID(i))))
Next
SQL1.ExecNonQueryBatch("SQL")
Catch
Log(LastException)
SQL1.Rollback
End Try
End Sub