Android Studio Sqlite Import method delete error

Question

Navigation

#1 by (0 votes)

0

You are not deleting the database table, Android Studio does not point to any errors when clicking the button the program does nothing

(NA ACTIVITY DatabaseHelper) public void delete () {

    SQLiteDatabase db = getWritableDatabase();
    db.execSQL("DROP IF TABLE EXISTS mylist_data");
    onCreate(db);

}

(NA ACTIVITY MainActivity) (On) public class MainActivity extends AppCompatActivity {

DatabaseHelper myDB;
Button button, button4, button2, button5;
EditText editText, editText2, editText3, editText4;

(Below the time to call the method)

button2.setOnClickListener (new View.OnClickListener () { @Override public void onClick (View v) {

        myDB.delete();

android

asked by anonymous 21.05.2017 / 19:04

1 answer

How to put the RSS Feed next to the Google Map API How to encrypt PHP code? [duplicate]

score 0 · Answer 1

I did not test your code but looking at:

db.execSQL("DROP IF TABLE EXISTS mylist_data");

It looks like you're putting FI before TABLE.

The correct one would be:

db.execSQL("DROP TABLE IF EXISTS mylist_data");