B4J Question [SOLVED] SQL.ExecNonQuery2 does not work

Knoppi · Oct 25, 2018

B4X:

SQL.ExecNonQuery2( "INSERT INTO test VALUES ( ?)", Array As Object( "TEST"))  'this works
SQL.ExecNonQuery2( "INSERT INTO ? VALUES ( 'TEST')", Array As Object( "test"))  'but this fails

org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near "?": syntax error)

I need a few hints why the second command does not work

Daestrum · Oct 25, 2018

I dont think the tablename can be a parameter.
You could use something like

B4X:

Dim Table_Name as String = "test"
…
SQL.ExecNonQuery2( $"INSERT INTO ${Table_Name} VALUES (?)"$, Array As Object( "TEST"))

Erel · Oct 25, 2018

Tips:
1. Tou can write Array instead of Array As Object. It is the same thing.

2. @Daestrum answer is 100% correct. You should however know that the query is no longer safe from SQL injections. If the table name somehow comes from user input then you should think about it.

B4J Question [SOLVED] SQL.ExecNonQuery2 does not work

Knoppi

Active Member

Daestrum

Expert

Erel

B4X founder

Similar Threads

B4J Question [SOLVED] SQL.ExecNonQuery2 does not work

Knoppi

Active Member

Daestrum

Expert

Erel

B4X founder

Similar Threads

Privacy & Transparency

Privacy & Transparency