Top "Android-sqlite" questions

SQLite Syntax for Creating Table with Foreign Key

I'm creating a table with foreign key references. I'm wondering about the required syntax. Mostly I've seen the following (from …

sqlite android-sqlite

Insert in SQLite Database android

im new on Android. I have some trouble with the insert statement in the database, when im running the application …

android insert android-sqlite

Android: SQLite saving string array?

I need to save a string array to the database but it won't let me. This is what I have: …

android android-sqlite

Create a foreign key in SQLite database browser

Sorry for novice question. I have created my tables using SQLite database browser, but: I do not know how can …

android-sqlite sqlite

Using String[] selectionArgs in SQLiteDatabase.query()

How do I use the String[] selectionArgs in SQLiteDatabase.query()? I wish I could just set it to null, as …

android android-sqlite android-cursor

Will SQLite performance degrade if the database size is greater than 2 gigabytes?

Last year when I checked about SQLite on their web site, the recommended SQLite database size was 2 gigabytes. But now, …

sqlite android-sqlite

java.lang.IllegalArgumentException: column '_id' does not exist

I'm trying to debug my application on a real device but I get this error: ERROR/AndroidRuntime(981): Caused by: java.…

android android-sqlite

java.lang.IllegalStateException: attempt to re-open an already-closed object(Tried closing )

public int getRecordsCount() { String countQuery = "SELECT * FROM " + TABLE_LOGIN; SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor = db.rawQuery(countQuery, null); if(…

android sqlite android-sqlite

How to reset SqLite database in Android?

I want my users to be able to reset the application, then I need to reset the SQLite database that …

android sqlite android-sqlite

Insert JSON data into the SQLite database in android

I want to insert the data from JSON array into the SQLite database. I have created two classes CategoryHelper.java …

android json sqlite android-sqlite sqliteopenhelper