Top "Android-sqlite" questions

Android uses SQLite to store and retrieve data persistently.

Retrieve database or any other file from the Internal Storage using run-as

On a non-rooted android device, I can navigate to the data folder containing the database using the run-as command with …

android database android-sqlite adb internal-storage
SQLite Order By Date1530019888000

Every record in my SQLite database contains a field which contains a Date stored as a string in the format …

sql sqlite android-sqlite sql-order-by
How to use ROW_NUMBER in sqlite

Here is my query given below. select * from data where value = "yes"; My id is auto increment and below there …

sqlite android-sqlite row-number
Caused by: android.database.sqlite.SQLiteException: no such table: (code 1) Android

We have a sqlite database in our Application. Its working fine for all the users but few of them experiencing …

android android-sqlite
Android SQLite issue - table ... has no column named

I'm getting this error - 07-03 12:29:18.643: E/SQLiteLog(5181): (1) table accounts has no column named otherNotes This is my code: private …

android sqlite android-sqlite
How can I create a list Array with the cursor data in Android

How can I create a list Array (the list display First Alphabet when scroll) with the cursor data?

android arraylist android-sqlite android-cursor
Android SQLite Insert or Update

as can be seen in the documentation the syntax to make insert or update is : INSERT OR REPLACE INTO <…

android android-sqlite
How to Add a Boolean Column in Android SQlite

I have created a table for my ContentProvider using the following line : static final String CREATE_DB_TABLE = " CREATE TABLE " + …

android sqlite android-sqlite
get a single row from table

These are the ids in my table: KEY_ID(autoincremented integer primary key) KEY_NAME(text) KEY_PH_NO(text) 1 …

android-sqlite
Android SQLiteOpenHelper: Why onCreate() method is not called?

I am trying to make my first Android app. I noticed that the SQLiteOpenHelper.onCreate() method is not called to …

java android android-sqlite