database - Passing an SQLiteDatabase delete function a table name as a String in Android -


if run:

void deletetablerecords() {         sqlitedatabase db = this.getwritabledatabase();         db.delete(table_albums,null,null);         db.close();     } 

i intended result. however, if run:

void deletetablerecords(string tablename) {         sqlitedatabase db = this.getwritabledatabase();         db.delete(tablename,null,null);         db.close();     } 

with call of deletetablerecords("table_albums") crash , told that:

android.database.sqlite.sqliteexception: no such table: table_albums 

what should passing table name if not string?

table_albums name of variable. value else.

i guess assigned value table_albums, example:

private static final string table_albums = "somevalue"; 

in case need pass actual value, not name of variable:

deletetablerecords("somevalue"); 

a better approach make public constant:

public class dbhelper {     public static final string table_albums = "somevalue";      // ...  } 

so can access in static way:

deletetablerecords(dbhelper.table_albums); 

Comments

Popular posts from this blog

java - Static nested class instance -

c# - Bluetooth LE CanUpdate Characteristic property -

JavaScript - Replace variable from string in all occurrences -