Wild card in SelectSQL

Databases
1

I am getting a database (syntax) error on the following statements:

sql = "SELECT HashValue FROM ?"
rs = theDB.SelectSQL (sql, tablename)

The error message is near "?": syntax error

Is using a wildcard for the tablename legal?

Data: Windows 10, Xojo 2021r2, Sqlite

2

You could just do:

sql = "select HashValue from " + tablename
rs = theDB.SelectSQL (sql)

How is tablename declared? And does the sql match the schema?

3

No, it’s not legal there. You’ll need to do something like SELECT * FROM “”“ + TableName.ReplaceAll(“”””, “”””””) + “””;” instead.

4

That’s what I thought. :slightly_frowning_face: I was hoping to avoid string concatenation but that’ll have to be the route I’ll take.

5

Tablename is a string and, yes, the sql matches the schema.

I use wildcards frequently in various WHERE clauses but having it in the FROM clause would make things a bit easier for me. Ah, well…

6

I’m not saying you can’t do it - haven’t tested that.