Problema com query ( mysql)
Dim Query As String
Dim connection As New MySqlConnection(connStr)
connection.Open()
Query = "UPDATE test SET play ='" + "0" + "',"
Query = Query + " front = '" + "0" + "',"
Query = Query + " back = '" + "0" + "',"
Query = Query + " value = '" + "50" + "',"
Query = Query + " item = '" + "0" + "',"
Query = Query + " WHERE dbid = '2' "
Dim cmd As MySqlCommand = New MySqlCommand(Query, connection)
Dim i As Integer = cmd.ExecuteNonQuery()
If (i > 0) Then
Timer1.Enabled = True
Else
Label4.Text = "Não foi possível conectar-se com o aplicativo móvel."
End If
connection.Close()
O visual basic informa que : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE dbid = '2'' at line 1, como consertar essa síntaxe?Discussão (5)
Carregando comentários...