android android-sqlite

Hi, I am trying to execute an .sql-file in my onCreate()-method of my SQLiteOpenHelper to create all tables of the db and to populate them with…

Hello everyone, I am programming an application for the iconia tab (android 3.0). In this application I want to access a sqlite database that is…

I am attempting to make an organizer for my college classes. I have everything setup to the point where I can add a course, which is then displayed…

In my application i have two two data management sources, one through web services and another stand by in sqlite database in the device itself. In…

I'm trying to track down a bug I see coming back from remote crash uploads from my clients where it's as if there is no data in my SQLLiteDatabase…

Hi, I am converting mysql database to sqlite 3 database using the script provided here: http://www.jbip.net/content/how-convert-mysql-sqlite But…

I have two classes, both are not activity, one is to perform database operation and one is to forward the values as mediator class. DataBase class…

Hello, I'm trying to debug my application on a real device and having an error. But when testing on emulator, the error didnt show up. Here is the…

From reading I've understood the way to implement my many-to-many relationship was to have a separate 'Routing Table'. Here's an example of how I've…

Hello all, I've been stuck on this for a few hours now. I have an Activity that calls a method to write some values into a database, it works,…

(date('now') > date('date_added','+60 seconds') AND subscribed<2) use that on android (with update method) to remove old records from the…

How can I query my SQLite database of my application from a terminal? I need it to debug purposes, and also to check values.

Hi, I'm using the SQLite with Android, and I want to know the best way to get the generated id of the row I inserted. A solution I think is make a…

I have another post here that is similar to this one, however, i have made some changes to my classes and having a different issue now. The previous…

I've seen other questions about this exception, but all of them seem to be resolved with the solution that a row with the primary key specified…

What is weird about this is it doesn't happen every time. I am adding something to the database and if i do it a couples of times nothing happens,…

Hello, A few days ago i was experiencing an error which was caused by a call to db.close() inside the onCreate() method. Some more people had…

My app I'm working on is a collection of notes organized by Contacts. I am having a problem using the cursor to query the database for the correct…

I have a table containing a BLOB column (it's just 16 bytes). I want to run a query of the form SELECT * FROM myTable WHERE blobColumn = ? and bind…

I'm trying to use the built in sqlite functions and I'm not sure how to format it. my question is how to format the where clause and the ? that can…