I have this SQL statement that I want to execute:
db.execSQL("DELETE * FROM " + TABLE_NAME + " WHERE " + DATE_TO_REMIND + "='" +
date + "'");
Which, if I were running it today, translates to:
"DELETE * FROM Vocabulary WHERE dateToReming ='2016/03/28'"
This is throwing errors in the logcat though that point to the *, but I
can't understand what it is saying is faulty about this statement. Here is
the error:
java.lang.RuntimeException: Unable to start activity
>> ComponentInfo{nuffsaidm8.me.activeenglish/nuffsaidm8.me.activeenglish.CheckVocabActivity}:
>>
>> android.database.sqlite.SQLiteException: near "*": syntax error (code 1): ,
>> while compiling: DELETE * FROM Vocabulary WHERE Date_To_Remind='2016/03/28'
>
>
>> at
>> android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2416)
>
>
>> at
>> android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)
>
>
>> at android.app.ActivityThread.-wrap11(ActivityThread.java)
>
>
>> at
>> android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344)
>
>
>> at android.os.Handler.dispatchMessage(Handler.java:102)
>
>
>> at android.os.Looper.loop(Looper.java:148)
>
>
>> at android.app.ActivityThread.main(ActivityThread.java:5417)
>
>
>> at java.lang.reflect.Method.invoke(Native Method)
>
>
>> at
>> com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
>
>
>> at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
>
>
>> Caused by: android.database.sqlite.SQLiteException: near "*": syntax
>> error (code 1): , while compiling: DELETE * FROM Vocabulary WHERE
>> Date_To_Remind='2016/03/28'
>
>
>> at
>> android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native
>> Method)
>
>
>> at
>> android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887)
>
>
>> at
>> android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498)
>
>
>> at
>> android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
>
>
>> at
>> android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
>
>
>> at
>> android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
>
>
>> at
>> android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674)
>
>
>> at
>> android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1605)
>
>
>> at
>> nuffsaidm8.me.activeenglish.DBHelper.getWordsToReview(DBHelper.java:77)
>
>
>> at
>> nuffsaidm8.me.activeenglish.CheckVocabActivity.onCreate(CheckVocabActivity.java:55)
>
>
>> at android.app.Activity.performCreate(Activity.java:6251)
>
>
>> at
>> android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107)
>
>
>> at
>> android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369)
>
>
>> at
>> android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)
>
>
>> at android.app.ActivityThread.-wrap11(ActivityThread.java)
>
>
>> at
>> android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344)
>
>
>> at android.os.Handler.dispatchMessage(Handler.java:102)
>
>
>> at android.os.Looper.loop(Looper.java:148)
>
>
>> at android.app.ActivityThread.main(ActivityThread.java:5417)
>
>
>> at java.lang.reflect.Method.invoke(Native Method)
>
>
>> at
>> com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
>>
>
>
>> at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
>
>
--
You received this message because you are subscribed to the Google Groups
"Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/android-developers.
To view this discussion on the web visit
https://groups.google.com/d/msgid/android-developers/acbf2bb0-076c-4957-a69f-0b9510e45b10%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
