how to solving SQLiteFulException in greenDao when I delete record from table? this is my stacktrace : android.database.sqlite.SQLiteFullException: database or disk is full (code 13) at android.d...

I'm using Room in order to persist data. I have a Entity that has an automatically generated (autoGenerate) primary key that mimics a ticket system. On every application run I need this key to star...

We have a sqlite database in our Application. Its working fine for all the users but few of them experiencing the Caused by: android.database.sqlite.SQLiteException: no such table: generalSettings ...

I want my users to be able to reset the application, then I need to reset the SQLite database that I have created. How can I do that? I want to reset the database or delete and recreate the databa...

I have read various on site about this issue but I am not able to figure this out. I am using pre-build database for this app. I am using jellybean for this app. AndroidManifest.xml <?xml vers...

I store date from Calendar.getTimeInMilliseconds() in SQLite DB. I need to mark first rows by every month in SELECT statement, so I need convert time in milliseconds into any date format using SQLi...

Error this line : mDataBase = SQLiteDatabase.openDatabase(dbPath, "123", null, SQLiteDatabase.NO_LOCALIZED_COLLATORS); When open the database . but whats Wrong? how to open database with passwo...

I am coding a Xamarin Android application, and am getting an error when trying to create a SQLite database. Here is my code: string applicationFolderPath = System.IO.Path.Combine(System.Environme...

I'm trying to build a simple application where the user isn't allowed to insert duplicate values. I'm trying PRIMARY KEY as one of the constraints and NOT NULL also. But NOT NULL doesn't seem to wo...

Please don't mark this duplicate. I searched a lot and have gone through number of posts before posting this. I am working on Cordova. I have an android 5.1.1 device on which I am testing the app. ...

I am getting below error: not an error (code 0): Could not open the database in read/write mode. I have added <uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" /&g...

I have this error popping out in logcat all the time. It always shows after every change of activity. And sometimes, the app disappears and in a second it shows again. There is not any fatal error ...

I want to create a table in SQLite in which one of the field is for date, in which date and time of current instance should save. Which data type should I use? I'm planning to use 'timestamp'. How...

Please prompt, how used REGEXP in SQLite? Realization: SELECT field FROM table WHERE field REGEXP '123' It is not working. Error: no such function: REGEXP

Here is my query given below. select * from data where value = "yes"; My id is auto increment and below there is result of given query. id || value 1 || yes 3 || yes 4 || yes 6 || yes 9 || yes...

In my application I'm getting this database disk image is malformed (code 11) error for some users. I googled it and come to know that when db image is malformed Android deletes it and recreate new...

We are trying to set the value of a global variable declared in the code below class MyApplication: Application() { var globalVar = 2 } Now we have a Main Activity that has a Edit Text named e...

I am having data like this 1 A 1 B 1 C 1 D 2 E 2 F 3 G 3 H 3 I 3 J 3 K by using this query select ABSTRACTS_ITEM._id,Name from ABSTRACTS_ITEM , ABSTRACT_AUTHOR , AUTHORS_ABSTRACT where ABSTRAC...

I'm trying to setup Room database backup functionality. Problem is that sql database file doesn't contain latest set of data in the app once downloaded. It always misses some most recent records. ...

I have an SQLite DB where I perform a query like Select * from table where col_name NOT IN ('val1','val2') Basically I'm getting a huge list of values from server and I need to select the ones...

I am developing an app and I know my database *.db will appear in data/data/com.****.*** I can access this file from AVD in Eclipse with help of sqlite manager But I can't access this file in my An...

I want to save in my Room database an object where one of the variables can either be of on type or another. I thought a sealed class would make sense, so I took this approach: sealed class Blueto...

I want to convert .sql file to .sqlite. i got the script from here link I am trying to execute script like this ./mysql2sqlite country.sql | sqlite3 mysqlite3.db but getting error like this b...

Error: 07-03 12:29:18.643: E/SQLiteLog(5181): (1) table accounts has no column named otherNotes Code: private static final int DATABASE_VERSION = 1; private static final String DATABASE_NAME = &q...

I am using RoomDB in my app. able to perform crud operations. Actually i want to see the db file. getDatabasePath("user.db").getAbsolutePath(); above code is giving me the directory where the db...