sqlite

Error with spinner

There is an error when i run my android program. My Booking.java package one.two; import android.app.ListActivity; import android.database.Cursor; import android.os.Bundle; import android.widget.SimpleCursorAdapter; import android.widget.Spinner; public class Booking extends ListActivity { private DBAdapter db; /** Called w...

column _id does not exist

Hi, the error in my logcat is such Logcat 08-29 08:20:57.961: ERROR/AndroidRuntime(1766): java.lang.RuntimeException: Unable to start activity ComponentInfo{one.two/one.two.Booking}: java.lang.IllegalArgumentException: column '_id' does not exist 08-29 08:20:57.961: ERROR/AndroidRuntime(1766): at android.app.ActivityThread.performL...

Long type with SQLite and Zentus Jdbc driver

Hi there, I am using SQLite in Java code through Zentus. I need to map Java long primitive type in my database. For that I tried to create tables with the following statement: CREATE TABLE MY TABLE (...., LONG time, ...). Insertion into the database through Java with Zentus works perfectly but when retrieving the data, always through ...

QT and SQLITE problem during building

Hi, I'm developing a simple application to use sqlite, the problem is that the following code /* ... */ QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("hellogoodbye"); if (!db.open()) { QMessageBox::critical(0, qApp->tr("Impossibile aprire il database"), qApp->tr("Non ...

application crashes while running on device due to sqlite assertion

HI I have developed the application on with sqlite Database .when i run the application in simulator it works perfect but when i tested with device application gets crashes. this is my code * Assertion failure in -[sampleProjectAppDelegate copyDatabaseIfNeeded], /Users/xxxx/Desktop/new/sampleProject/Classes/sampleProjectAppDelegate.m:...

Best practices for core data store (sqlite) backup?

I am working on an update for my new iphone app (FlashCards++) which will include the ability to back up & restore the core data store (sqlite). I have been looking for good options for how to do this but there are very few resources about this. What are the best practices that you have found for doing core data backup? I'd like to keep ...

SQLITE_BUSY error

Hi everyone, I have a last probleme before finishing my application. I use SQLITE DataBase. Everything works perfectly on the simulator, but when i run the app on my Iphone with Dev provisionning profile, i got an error on the sql methods : I have a method that executes the following code : if(sqlite3_prepare_v2(database, sqlState...

Unit testing NHibernate application with SQLite: it writes to the database but cannot read back

I have an application using NHibernate that is already deployed and working properly, and I'm re-factoring the unit tests to use SQLite for improved performance, and to keep unit test data out of the "real" database. I have a simple test that creates an Calendar entity, saves it, then tries to read it back and verifies that it's the sam...

SQL inner join two tables with the same column names

Hello I have two tables with a variable amount of columns. (I don't know how many columns or what there names will be) for example Table A and Table B. TableA: ID | B_ID | {variable} TableB ID | {variable} Query: SELECT TableA.*, TableB.* FROM TableA INNER JOIN TableB ON TableA.B_ID= TableB.id; When TableA and TableB bot...

A pointer in the right direction

I have been developing a Mac Desktop app with an iOS device counterpart. Basically I want to upload event information (music gigs etc.) from the Desktop to an online database and be able to read (only) the information whilst mobile. I've got both apps working, using Core Data (with a sqlite database - I was going to use XML but the iOS ...

Android database recreates everytime application is launched

Why is SQLiteOpenHelper calling onCreate() every time my application starts up. Here's my code for onCreate() @Override public void onCreate(SQLiteDatabase db) { Log.i("onCreate()", "Enter"); //create cards table db.execSQL( "create table circles" + "("+ "id integer primary key,"+ "x inte...

Loop and strings in Ruby/SQLite3

Hello, So I need to run a loop in Ruby to pass some strings into SQLite. Basically I have a table that looks like this: pID Data 1649,1650,1651|Some data 1643,3|some more data 23,4,5,6,7|More data Now in my SQLite queries, I will sometimes need to pass all the pIDs for a given line through as one whole string, which I ca...

Changes to SQLite are lost after connection.Close()

Working with MonoTouch .NET for iPhone and SQLite on Mac OSX. I can read from the database no problem. However, when I attempt to make changes to the database, I get strange behavior. The code below runs without exception, but no real changes are being made to the database. I can create a table, insert a record, select that record, and d...

how to take sqrt in sqlite

hi guys, This is the query of PHP using MySQL. can anyone please convert this query to sqlite query? Query: select SQRT(POW(latitude, 2) + POW(longitude, 2)) *110 as dist from route Best Regards, Thanks ...

Question with android

How would i make what i selected in the spinner appear in a textview when i choose that selection? The data would be taken from the database. My Booking.java package one.two; import android.app.Activity; import android.database.Cursor; import android.os.Bundle; import android.view.View; import android.widget.AdapterView; import androi...

Android SQLite insert unique

Hello all, Simple enough question, but I cant find ant half-decent documentation on it. Right so I've created my SQLite db but it has two problems or one depending how you look at it! The db creates fine and I can show the data in a basic listview, however on changing the orientation of the phone/emulator the insert statements run again...

search in joint tables

I have four tables: cuisines(id, name); recipes(id, cuisine_id, name, picture); ingredients(id, name); ingredients_recipes(ingredient_id, recipe_id); the last table references the Many-To-Many relationship between recipes and ingredients. How can I select all cuisines which contain tomatoes (i.e. the cuisine has recipes which have ...

sqlite constraint failed error code

Hi all, I have two tables albums and songs and each song has reference to alum's id. Album table : CREATE TABLE albums (id INTEGER PRIMARY KEY ASC, name TEXT, additional TEXT) Song table: CREATE TABLE songs (id INTEGER PRIMARY KEY ASC, album_fk INTEGER NOT NULL, title TEXT, url TEXT, duration BIGINT NOT NULL) and i also have a tri...

Managing an Android database

I'm looking to implement my first Android database, but I have so many questions which (I believe) are unanswered by all the tutorials I find. Here are my needs: - I want my application to have a database that is persistent. If my application closes and launches again, there is already a database to pull data from. It does not create ...

What SQLite column name can be/cannot be?

Is there any rule for the SQLite's column name? Can it have characters like '/'? Can it be UTF-8? ...