I receive the following error when attempting to create a new table with RDC.
Error:
I am attempting to set the new table name with a parameter (? == Phone IMEI)
Server Config:
Error:
B4X:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ''833521620800013' (id INT NOT NULL AUTO_INCREMENT,imei CHAR(45),contactid CHAR(4' at line 1
B4X:
Sub RDCcreateContactsTable
Dim imei As String = MyIMEI
Dim cmd As DBCommand
cmd.Initialize
cmd.Name = "create_contactstable"
cmd.Parameters = Array As Object(imei)
reqManager.ExecuteCommand(cmd,"create_contactstable")
End Sub
B4X:
sql.create_contactstable= CREATE TABLE ? (\
id INT NOT NULL AUTO_INCREMENT,\
imei CHAR(45),\
contactid CHAR(45),\
name CHAR(60),\
note CHAR(150),\
starred CHAR(45),\
mobile1 CHAR(45),\
mobile2 CHAR(45),\
mobile3 CHAR(45),\
other1 CHAR(45),\
other2 CHAR(45),\
other3 CHAR(45),\
email1 CHAR(80),\
email2 CHAR(80),\
email3 CHAR(80),\
picture BLOB,\
PRIMARY KEY (id),\
UNIQUE INDEX id_UNIQUE (id ASC)\