sqlite

error: SQLitePersistentObject.h: No such file or directory

I am trying to use SQLitePersistentObject in my iphone project. I am including all the files in SQLitePersistentObject in my project.I have also added libsqlite3.dylib library under the Linked Libraries section. The instruction for using SQLitePersistentObject on http://code.google.com/p/sqlitepersistentobjects/source/browse/trunk/ReadM...

Android: I cant seem to add to my database

So basically my app starts out with a TabView, then through the options menu the user selects to add a game to the database. This opens the InputGame class, which accepts a few values, and then it should put them into a database when the user clicks "Submit". It will also go back to the original home view. The app goes back the the home...

Error with Database in eclipse

Hi, here is my Arrival.java package one.two; import java.io.IOException; import java.util.ArrayList; import java.util.List; import android.app.ListActivity; import android.database.Cursor; import android.os.Bundle; import android.widget.ArrayAdapter; import android.widget.ListView; import android.widget.SimpleCursorAdapter; public cl...

How do I put and replace a file using in a client machine in a Silverlight app?

Hi, I'm trying to make a Silverlight app which has a local sqlite file to search some data when the app gets offline. I found the following library, http://code.google.com/p/csharp-sqlite/ and it seems pretty nice. So, what I want to know is, what is a good approach to have and place a file which might be replaced by automatically when...

How do I statically link sqlite to my android application?

I need to statically link the 3.6.2 version of SQLite against my android application due to a bug that affects the dynamic library bundled with Android < 2.2. I've already compiled and installed 3.6.2 on my development machine, but I'm not sure how I go about linking it to my Android app (developing with Eclipse). I'm not familiar with ...

Alternative to Sqlite for iPhone [monotouch]

Like the title says. I find a lot of the issues I have are related to the lack of thread safety in the Sqlite wrapper needed for using Sqlite with Monotouch - so - the question is - is there an alternative? There must be something!!? w:// ...

SQLite + Entity Framework 4.0 + Identity column/Autoinc does not work

Hello, thats my table: -- Original table schema CREATE TABLE [SchoolYear] ( [Start] datetime NOT NULL, [End] datetime NOT NULL, [Id] integer PRIMARY KEY ON CONFLICT ABORT AUTOINCREMENT NOT NULL ); my Entity in the EF designer has StoredGeneratedPattern set to Identity OR Compute and datatype is int64. Everytime I insert a...

DBMetal (SQLite): "Sequence contains more than one element" with multiple foreign keys

When trying to create a C# file using DbMetal (as part of DbLinq), I get the following error: DbMetal: Sequence contains more than one element It's only appearing when I reference multiple foreign keys as part of my primary key. The following is the DDL for my table causing issues: CREATE TABLE [QuestionChoice] ( [Questionair...

Android SQLite: How to insert data in to a single column of an existed table

Hallo all, I have two files, one called "part1.txt" and another one called "part2.txt", which look like following part1.txt part2.txt lili like eating apple lucy like playing football Now i want to insert the contents of these two files into a single table with the schema table_name(linefromp...

SQLite short file names 8.3

Hello I am attempting to compile SQLite for an operating system that does not support long file names. The max file name is 8 chars long with an extension of 3 chars (8.3). Currently a "-journal" is created while using SQLite this breaks the file name rule and stops SQLite with "Disk I/O Error" I have tried to disable the journal f...

An IF statement in a cursor adapter??

private void datafill() { Cursor notesCursor = mDbHelper.fetchAllNotes(); startManagingCursor(notesCursor); /* JournalRowId is the row id from the first database containing all journal names All notes are kept in database 2. I want only the notes that correspond to each journal to be listed, KEY_...

Query works in Sqlite with strings. When vars passed to query in Tcl it breaks.

I have a Sqlite notes database with a "Toxi" schema (Notes table, Tags table, Note-has-Tag table called "fkeys"). There is another thread that goes into this, and the querying of it, it great detail. The interface or "front end" is a Tcl script run from Tclsh. The Tcl version works just fine if I just have 1 arg and no INTERSECT. In Sqli...

Storing currency values in SQLite3

I'm dealing with lots of different currencies in my application, and I want to know what the "best" way is to store them in an SQLite3 database. I'm leaning towards a fixed-point representation (i.e. store them as integers, where $3.59 gets stored as 359, ¥400 stored as 40000). Is this a good idea? What if my input data later changes an...

Does anyone have example code for a sqlite pipeline in Scrapy?

I am looking for some example code of a SQLite pipeline in Scrapy. I know there is no built in support for it, but I'm sure it has been done. Only actual code can help me, as I only know enough Python and Scrapy to complete my very limited task, and need the code as a starting point. ...

Re-order an array

I have a list of bookmarks stored in NSUserDefaults. For each bookmark entry I retreive data from a sqlite database. I then create an array of these bookmarks. Each bookmark in the array is represented as a person object. How ca I re-order the array to sort by the persons first name? ...

Hardcore SQL(ite) : fetch segment intersection.

Hi folks ! So this one is a very difficult one I think, so I'll try to make it as clear as possible. So basically, I have geographic datas : Nodes (#ID,lat,lng) WayNodes (#ID,#node_id,#way_id, sequence) Ways(#id,name) And what I want is to get the intersection of two GROUPS of ways. For example I need to find intersection(s) between...

NotSupportedException at unboxing SQLite Int64 field with Entity Framework 4

Querying with Entity Framework 4 with a SQLite (v3) database through the sqlite.phxsoftware.com ADO.NET provider (v1.0.66.0), I'm facing the following NotSupportedException while casting the retrieved Int64 properties: Unable to cast the type 'System.Int64' to type 'System.Object'. LINQ to Entities only supports casting Entity Data Mode...

SQLite -> finding two closest points to two different points

Hi everybody. So I have 2 tables : route(#id) step(#id,route_id,lat,lng,sequence_order) And 2 GPS coordinates : M1(lat1, lng1) M2(lat2, lng2). So I want to find all the routes which have at least one step closer than 1.0 mile from each of the 2 GPS coordinates with a ascending sequence order. So if I find Route#25 which has a step ...

SELECT MAX(column) returning only column name

Hi, This has got me all confused! I'm trying to return the max value from a column in my database but the return value is always the name of the column. The query I use: private static final String SELECTMAX = "SELECT MAX(?) FROM " + TABLE_NAME ; The (test) function to return the max value: public int getMaxValue(String field...

Android itemized overlay Array slowing down

Hi hi, I've got a script which gets data from a MySQL database through an http request, puts it into a json array, then puts each item into an itemized overlay array so that each item can be put onto a map. Problem is, it takes > 5 minutes to load all the items into the itemized overlay, and is then dog-slow at actually running. It sta...