dhernandez Active Member Licensed User Longtime User Nov 22, 2013 #1 Good day colleagues. I am working with RDC, but when trying to insert some data to my MySQL I mark the following error: Code: Copy java.sql.SQLException: Can not issue data manipulation statements with executeQuery(). My query is this; Code: Copy sql.insert_RDC=INSERT INTO TablaRDC(nombre, correo, ocupacion) VALUES (Sunday, [email protected], Programmer) My code is this: Code: Copy Sub RInsert(Name As String) Dim cmd As DBCommand cmd.Initialize cmd.Name="insert_RDC" cmd.Parameters= Array As Object(Name) ReqManager.ExecuteQuery(cmd, 0, Null) end sub
Good day colleagues. I am working with RDC, but when trying to insert some data to my MySQL I mark the following error: Code: Copy java.sql.SQLException: Can not issue data manipulation statements with executeQuery(). My query is this; Code: Copy sql.insert_RDC=INSERT INTO TablaRDC(nombre, correo, ocupacion) VALUES (Sunday, [email protected], Programmer) My code is this: Code: Copy Sub RInsert(Name As String) Dim cmd As DBCommand cmd.Initialize cmd.Name="insert_RDC" cmd.Parameters= Array As Object(Name) ReqManager.ExecuteQuery(cmd, 0, Null) end sub
Erel B4X founder Staff member Licensed User Longtime User Nov 24, 2013 #3 You should use ExecuteCommand instead of ExecuteQuery. Upvote 0
dhernandez Active Member Licensed User Longtime User Nov 25, 2013 #4 Excelente Erel, era eso que estaba mal... ya verifiqué y realicé los ajustes. Gracias Erel Upvote 0