it4Astuces
it4Astuces

Reputation: 439

SQLite database : data folder persmission

I am beginner in android developpement so I try to learn working with SQLite database. My problem is that I can't access to the contents of data folder in DDMS. I created a simple Product table in "sample.sqlite" database using SQLiteBrowser and I copied It in assets folder but when I tried to access it, I get this error :

E/AndroidRuntime(10081): Caused by: android.database.sqlite.SQLiteException: no such table: Product (code 1): , while compiling: SELECT * FROM Product

And when I check my data folder in the DDMS, I can't access to It's folders, I gess It's because of folder's permission: ("drwxrwx--x"=read only). So can anyone help me here?

Upvotes: 0

Views: 130

Answers (1)

LoveForDroid
LoveForDroid

Reputation: 1142

You do not need to copy the sqlite table into assets folder. Once you create the table, you should be able to CURD on it using SQLiteOpenHelper class. I suggest you follow some tutorials like this before moving on:

http://www.vogella.com/tutorials/AndroidSQLite/article.html http://www.tutorialspoint.com/android/android_sqlite_database.htm

Upvotes: 3

Related Questions