Android Question ExecuteRemoteQuery to Update Table

P

Puthut Wibowo

Member
Licensed User
Hello, all
I am trying to make an Update Table from MYSQL in accordance with "Connect Android to MySQL Database Tutorial". MYSQL Syntax for Updates

B4X: 
ExecuteRemoteQuery(("UPDATE tbl_assesment_kecanggihan SET idtingkatkecanggihan=?, skor=? Where id_assesment_kecanggihan=?, VALUES ('" & IdCanggih & "' ,'" & SpinPenilaian.SelectedItem & "' ,'" & IDAssCanggih &"'"), UpdateAssCanggih)


Error appears

B4X: 
ResponseError. Reason: Internal Server Error, Response: UPDATE tbl_assesment_kecanggihan SET idtingkatkecanggihan=?, skor=? Where id_assesment_kecanggihan=?, VALUES ('2' ,'1' ,'111'\nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, skor=? Where id_assesment_kecanggihan=?, VALUES ('2' ,'1' ,'111'' at line 1


Can anyone help me from this error?

Thank you before
 
Sort by date Sort by votes

udg

Expert
Licensed User
Longtime User
Missing closing parenthese
IDAssCanggih &"'"), UpdateAssCanggih)
Click to expand...
It should be IDAssCanggih &"')")

It is strongly suggested to use it in the form:
sql.ExecNonQuery2("UPDATE students SET image = ? WHERE id = ?", Array(b, 10))
 
Last edited:
Upvote 0
P

Puthut Wibowo

Member
Licensed User
B4X: 
 ,'" & IDAssCanggih &"')", UpdateAssCanggih)

still error.
B4X: 
Error description: Invalid number of parentheses.
Error occurred on line: 624 (FrmCLV)
ExecuteRemoteQuery(("UPDATE tbl_assesment_kecanggihan SET idtingkatkecanggihan=?, skor=? Where id_assesment_kecanggihan=?, VALUES ('" & IdCanggih & "' ,'" & SpinPenilaian.SelectedItem & "' ,'" & IDAssCanggih &"')", UpdateAssCanggih)




udg said:
Missing closing parenthese

It should be IDAssCanggih &"')")

It is strongly suggested to use it in the form:
sql.ExecNonQuery2("UPDATE students SET image = ? WHERE id = ?", Array(b, 10))
Click to expand...
 
Upvote 0

udg

Expert
Licensed User
Longtime User
B4X: 
ExecuteRemoteQuery(("UPDATE tbl_assesment_kecanggihan SET idtingkatkecanggihan=?, skor=? Where id_assesment_kecanggihan=?", Array( IdCanggih, SpinPenilaian.SelectedItem , IDAssCanggih), UpdateAssCanggih)
 
Upvote 0
P

Puthut Wibowo

Member
Licensed User
Still error :

Error description: Invalid number of parentheses.
Error occurred on line: 627 (FrmCLV)
Click to expand...

im trying insert ) after IDAssCanggih)
B4X: 
, IDAssCanggih))

but still error compiling
Error compiling program.
Error description: ')' expected.
Error occurred on line: 627
Click to expand...


 
Upvote 0
P

Puthut Wibowo

Member
Licensed User
Finally im find the answer :
B4X: 
ExecuteRemoteQuery("UPDATE tbl_assesment_kecanggihan SET idtingkatkecanggihan = '" & IdCanggih & "', skor = '" & SpinPenilaian.SelectedItem & "' WHERE id_assesment_kecanggihan = " & IDAssCanggih, UpdateAssCanggih)
 
Upvote 0
You must log in or register to reply here.

Similar Threads

P
  • Question
Android Question Sql Update
Replies
3
Views
758
Pesciolina
P
  • Question
Android Question SOLVED: SQLite concatenation
Replies
0
Views
967
peacemaker
B
  • Question
Android Question Help to perform the DBUtils.ExecuteMemoryTable
Replies
3
Views
2K
Bob Spielen
B
  • Question
Android Question Sqlite UPDATE with multiple arguments using WHERE
Replies
4
Views
3K
klaus
D
  • Question
Android Question UPDATE remote MySQL table with RDC
Replies
2
Views
1K
Declan
D
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…