Android Question RDC and SQLite - UPDATE Query problem

[matt humphreys]

I seek greater wisdom please....using the RDC/SQLite tutorial example...

I have included and UPDATE query in the config.properties using the ? variable that does not seem to recognise a table name as a variable.

why does this work...
sql.update_table=UPDATE animals Set name= ? WHERE name= ?
and this does not...
sql.update_table=UPDATE ? Set name= ? WHERE name= ?

Sub UpdateSQLiteTable
Dim cmd As DBCommand
cmd.Initialize
cmd.Name = "update_table"
cmd.Parameters = Array As Object("chook","emu") 'this works
cmd.Parameters = Array As Object("animals","chook","emu") 'this does not

reqManager.ExecuteCommand(cmd, Null)
End Sub

I hasten to add the error message:

java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "?": syntax error)

 

[Erel]

SQL doesn't allow you to parameterize the table name and columns.

 

[matt humphreys]

aaaah!
tks Erel, appreciate your time.