jeudi 16 avril 2015

SQLite cant create TABLE witch numeric name

But when i use some DBmanager i can add TABLE with numeric name. So that's some problem in my code?



String sql = "CREATE TABLE %s ( EN TEXT, RU TEXT, TRN TEXT, VOICE TEXT);";
sql = String.format(sql, 100);
preparedStatement = DbConnector.conn.prepareStatement(sql);
preparedStatement.executeUpdate();

*java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "100": syntax error)*

Aucun commentaire:

Enregistrer un commentaire