You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
there is an issue with making sql query for update.
if we use reserved words as column name or table name of out dabase we cannot update any of its fields from web interface because the query does not put names between `` signs.
here is an example
android.database.sqlite.SQLiteException: near "delete": syntax error (code 1 SQLITE_ERROR): , while compiling: UPDATE [Card] SET delete=?,default=? WHERE id=?
android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:986)
android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:593)
android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:590)
android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:61)
android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:33)
android.database.sqlite.SQLiteDatabase.updateWithOnConflict(SQLiteDatabase.java:1702)
android.database.sqlite.SQLiteDatabase.update(SQLiteDatabase.java:1650)
com.amitshekhar.debug.sqlite.DebugSQLiteDB.update(DebugSQLiteDB.java:50)
com.amitshekhar.utils.DatabaseHelper.updateRow(DatabaseHelper.java:331)
com.amitshekhar.server.RequestHandler.updateTableDataAndGetResponse(RequestHandler.java:347)
com.amitshekhar.server.RequestHandler.handle(RequestHandler.java:119)
com.amitshekhar.server.ClientServer.run(ClientServer.java:77)
java.lang.Thread.run(Thread.java:919)
The text was updated successfully, but these errors were encountered:
there is an issue with making sql query for update.
if we use reserved words as column name or table name of out dabase we cannot update any of its fields from web interface because the query does not put names between `` signs.
here is an example
The text was updated successfully, but these errors were encountered: