B4J Question [SOLVED] SQL.ExecNonQuery2 does not work

[Knoppi]

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]

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

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

 

[Erel]

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.