Android Question SQL-Error

[Deleted member 103]

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.

 

[Mahares]

Can someone please tell me what this error means?
SQL Error: unrecognized token:

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

 

[Deleted member 103]

Thank you so much! It works, so simple.

 

[Mahares]

SQL Error: unrecognized token:

Hey @Filippo:
If you insist to use your original table name, this will also work , use brakets like this: [20170111_210417]

 

[Deleted member 103]

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.