Typing " (double quotation mark) in the search box causes crash
Here's the logcat:
02-20 23:37:29.324 7176-7176/app.varlorg.unote.debug E/SQLiteLog: (1) unrecognized token: "" ORDER BY Date_creation DESC"
02-20 23:37:29.324 7176-7176/app.varlorg.unote.debug E/InputEventSender: Exception dispatching finished signal.
02-20 23:37:29.324 7176-7176/app.varlorg.unote.debug E/MessageQueue-JNI: Exception in MessageQueue callback: handleReceiveCallback
02-20 23:37:29.325 7176-7176/app.varlorg.unote.debug E/MessageQueue-JNI: android.database.sqlite.SQLiteException: unrecognized token: "" ORDER BY Date_creation DESC" (code 1): , while compiling: SELECT * FROM table_notes WHERE Titre LIKE "%"%" ORDER BY Date_creation DESC
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1318)
at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1257)
at app.varlorg.unote.NotesBDD.fillListNote(NotesBDD.java:238)
at app.varlorg.unote.NotesBDD.getSearchedNotes(NotesBDD.java:233)
at app.varlorg.unote.NoteMain$3.onTextChanged(NoteMain.java:221)
at android.widget.TextView.sendOnTextChanged(TextView.java:8186)
at android.widget.TextView.handleTextChanged(TextView.java:8248)
at android.widget.TextView$ChangeWatcher.onTextChanged(TextView.java:10370)
...