[Gambas-user] [Gambas Bug Tracker] Bug #1027: Unexpected behavior on Sqlite3 exec quotation

[bugtracker at ...3416...]

http://gambaswiki.org/bugtracker/edit?object=BUG.1027&from=L21haW4-

Comment #1 by Benoît MINISINI:

The &1, &2, ... substitution pattern are only for SQL *values*. You must not use them for SQL table of field names, which use a database-dependent different quoting mechanism.

To quote a field or a table name, you have to use the DB.Quote() method. 
By the way, quoting a value is done with DB.Subst() too.

Benoît MINISINI changed the state of the bug to: Rejected.