I have the codes work for loading images from the gallery but I really do not understand how it works. Here are the codes. @Override protected void onActivityResult(int requestCode, int resultCode,...

public Cursor getImages(long rowId) throws SQLException { Cursor mCursor = db.rawQuery("select * from Pictures WHERE id=" + rowId + ";", null); if (mCursor != null) { mCurs...

In my application I created the GridView to show the image from particular folder. The issue is that I want to retrieve images from the DCIM/100ANDRO folder. Which type of arguments should be passe...

Usually when I iterate over a cursor I use something like the following: while (cursor.moveToNext()) { // get stuff from the cursor } What's the best way to iterate an Android Cursor? has ...

There are many questions on SO about CursorWindowAllocatoinException: SQLite Android Database Cursor window allocation of 2048 kb failed Could not allocate CursorWindow Out of Memory when allocat...

I have an Android ContentProvider which allows to do LEFT OUTER JOIN queries on a SQLite database. Let's assume in the database I have 3 tables, Users, Articles and Comments. The ContentProvider i...

I'm using Intent.ACTION_GET_CONTENT which opens recent files. Selecting items from the recent files gives a bad URI but selecting the same file from the file manager gives a right URI which can be ...

I'm making an Kiosk app that use database. The app is running all time in foreground. The app have many threads that using one shared DataBaseHelper instance. the app works flawlessly but most of t...

Would it be OK to have a single instance of SQLiteOpenHelper as a member of a subclassed Application, and have all Activities that need an instance of SQLiteDatabase get it from the one helper?

I've executed some queries on my SQLite DB on Android. Main instruction used is this: Cursor cursor = myDB.rawQuery(select, null); Now I want the results of this query to be converted to a gen...

If cursor.moveToFirst() returns false do I still need to close it? Since it returns false when the cursor is empty. I'm doubt about the correct approach: if (cursor != null && cursor.move...

i want to select unique contacts from android only that contacts which have phone numbers. i am using this code ContentResolver cr = getContentResolver(); Cursor cur = cr.query(ContactsContract.C...

Im using a matrix cursor to add rows to cursor. Defined columns in the MainActivity on Create //In protected void onCreate String[] columns = new String[] { "dealername", "product","type","desc...

In Honeycomb the Loader APIs were introduced as the proper way to provide data to an application by doing the heavy lifting on a background thread. In my application I'm working to replace all my C...

i want to make an expandable listview, but the adapter will take cursor as input instead of array list. i would like to implement animation on collapse, https://github.com/idunnololz/AnimatedExpa...

Is there any way to GET the ContentValues object from the SQLite? It's very useful, that we can insert ContentValues in DB, and it should be more useful to get the CV from there.

I have a code: public String getNameUpdateEvent(long id) { Cursor mCursor = db.rawQuery("select name from events WHERE _id=" + id + ";", null); if (mCursor != null) { mCursor.moveToFirst(); }...

I used this code: Cursor c = cr.query(message, null, null, null, null); startManagingCursor(c); But startManagingCursor(c) is a deprecated method. How can i replace it?

I'm using Sqlite in Android and to get a value from the database I use something like this: Cursor cursor = sqliteDatabase.rawQuery("select title,category from table", null); int columnIndexTitle...

I am currently working with the Android Contacts content provider and currently can access a contacts full display name without issue using the following code: String[] PROJECTION = new String[] {...

I have one existing contact, I need to add a work address to that existing contact. I am using the following code, but it's not working. String selectPhone = Data.CONTACT_ID + "=? AND " + Data.MIM...

Im at a bit of loss on this one on how to produce sections in a ListView when you use both Cursors and a Custom SimpleCursorAdapter. Many of the docs out there reference using getView() etc, or cr...

I have a Spinner which is to show a list of data fetched from database. The data is returned to a cursor from query, and the cursor gets passed to spinner's SimpleCursorAdapter. It is working fine ...

how can I "convert" a Cursor to a JSONArray? my cursor as 3columns (_id, name, birth) I've searched but I can't not find any examples

I know this question has asked many times in SO,but i couldn't figure out my exact problem. I am using the following code to get the data from the database(Table1) and update another Table2 based ...