Android Question SQL-Error

D

Deleted member 103

Guest
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.

 
Sort by date Sort by votes
M

Mahares

Expert
Licensed User
Longtime User
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:
Upvote 0
D

Deleted member 103

Guest
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
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…