D Deleted member 103 Guest Jan 18, 2017 #1 Hi, Can someone please tell me what this error means? SQL Error: unrecognized token: Can perhaps the name "20170111_210417" not be used? The database already works, only the SQLite-Viewer can not open it. For info! The database has been created with the "DBUtils" module.
Hi, Can someone please tell me what this error means? SQL Error: unrecognized token: Can perhaps the name "20170111_210417" not be used? The database already works, only the SQLite-Viewer can not open it. For info! The database has been created with the "DBUtils" module.
M Mahares Expert Licensed User Longtime User Jan 18, 2017 #2 Filippo said: Can someone please tell me what this error means? SQL Error: unrecognized token: Click to expand... I am pretty sure that a SQLite table name MUST start with a letter, but I have not checked it recently with newer version of SQlite. If you change the table name to something like this, you will be good to go: A20170111_210417 Last edited: Jan 18, 2017 Upvote 0
Filippo said: Can someone please tell me what this error means? SQL Error: unrecognized token: Click to expand... I am pretty sure that a SQLite table name MUST start with a letter, but I have not checked it recently with newer version of SQlite. If you change the table name to something like this, you will be good to go: A20170111_210417
M Mahares Expert Licensed User Longtime User Jan 18, 2017 #4 Filippo said: SQL Error: unrecognized token: Click to expand... Hey @Filippo: If you insist to use your original table name, this will also work , use brakets like this: [20170111_210417] Upvote 0
Filippo said: SQL Error: unrecognized token: Click to expand... Hey @Filippo: If you insist to use your original table name, this will also work , use brakets like this: [20170111_210417]
D Deleted member 103 Guest Jan 19, 2017 #5 Hi @Mahares , so my app has no problems with the name because I use the brakets, the problem is only if one wants to open the database with other SQLite viewer. But if it is, then I can continue to use the name without brackets. Upvote 0
Hi @Mahares , so my app has no problems with the name because I use the brakets, the problem is only if one wants to open the database with other SQLite viewer. But if it is, then I can continue to use the name without brackets.
