android sqlite

I am trying to open a SQLite database in android, the database works fine in the sqlite browser, but android does not read that the table in…

Hi I have the below statement to update a row in the table ContentValues myValues = new ContentValues(); myValues.put("duedate", duedate); return…

I have the below code. Does this delete all the rows having name = myname? return mDb.delete(DATABASE_TABLE, NAME + "=?", new String[] { myname });…

I am getting an error with a rawquery on Eclipse on a DB in the assets directory. The DB is 'pre-loaded' with tables and data and the SQL string,…

So I'm trying to search through a column where the string is a comma separated list of words with no spaces such as one,two,three,four and so on.…

I'm having a problem with summing floats properly from my SQLite database. I have created my table as follows where I have set the column 'amount'…

All of the examples I've seen of using registerContentObserver() do so through a ContentProvider interface. But Cursor has a…

I have a large amount of data i want to import into one sqlite database. 4column and 150 rows. Currently the data is in a excel spreadsheet. How can…

is there an exampl on how to use listview with sqlite to read all rows in table at once or what do i change in the curser to make it read all the…

I have a folder on sdcard with videos. I created a SQLite database with video attributes(columns). I need to show video thumbnail with text and time…

I m accessing SQLite databse from the following location /data/data/files/examples/search.sqlite it works fine in Samsung Tablet but when i run the…

I m accessing SQLite databse from the following location /data/data/files/examples/search.sqlite it works fine in Samsung Tablet but when i run the…

I am creating a application with a database. I have one table that will have over 200 rows in it. (reference table used within the app) I have…

i want to update 2 columns of my android SQLite table named as CardDB in a reset function. 'Mark' and 'Read' these two field are integer type.…

I am new to android and i cant seem to find any easy way of inserting data from an excel sheet intot he sqlite db. i create the database in the…

I'm new to Android programming however I do have some Java experience. What I would like to know is, what is the best approach for storing…

package com.totsp.androidexamples; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase;…

What are the best data structure for tags (not nfc or html). Like tags that are used in stackoverflow to mark our messages. I was thinking of List…

I have a big text file containing SQL CREATE TABLE and INSERT statements. How do I import this file in the SQLiteOpenHelper onCreate method? Or, is…

I am trying to populate a map overlay with markers using lat and long from an existing SQLite database. I have found examples where you input the…