[Gambas-bugtracker] Bug #1647: SQLITE: INTEGER PRIMARY KEY AUTOINCREMENT is not SERIAL?

[bugtracker at gambaswiki.org]

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

Comment #6 by Benoît MINISINI:

Apparently you used backticks '`' around field names when creating the table. This is correct sqlite3 syntax, but it's not the standard SQL one, so the gb.db.sqlite3 parser fails to detect the field correctly.

I will try to support backticks. In the meantime, just use normal quotes around identifiers, and things should behave as expected.

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