sqlite

Convert .NET datetime to SQlite datetime

I've tried to query with a datetime in C#, database : SQlite. cmd.CommandText = @"select * from PhieuNhap where NgayNhap=$NgayNhap"; cmd.Parameters.Add(new SQLiteParameter("$NgayNhap", SqlDbType.DateTime).Value = ngayNhap; ngayNhap is a DateTime type. But it seems doesn't work this way . ...

SQlite & c#, unable to connect database error.

SQLiteConnection conn = new SQLiteConnection("Data Source=/data/bakkal.db3;"); conn.Open(); conn.Close(); I am new at programming so maybe the problem is a very dumb one, sorry for that. I am trying to connect my project with a database which exists in the directory listed above. But the project gives an error at "conn.Open();" line wh...

sql android something seems to b wrong how do you deduce from a cursor the query status

i have this code : private void insertValus() { ContentValues initialValues = new ContentValues(); for (int i = 0 ; i < COUNTRIES.length ; i++){ Character tmp = (Character)COUNTRIES[i].charAt(0); initialValues.put(VALUE, COUNTRIES[i]); initialValues.put(TYPE, "country")...

SQLite Used to Populate a ListView in WPF C#

I have an SQLite database with over 100,000 records. I need the data to fill a ListView in my WPF project. I'm using System.Data.SQLite. What's the (best) way to get this setup so it works using virtualization? Also, what's the best method to filter the list view based on key word searches? I'm aiming for maximum speed. ...

Querying dates in NSPredicate doesn't seem right: not able to match future dates

I have some XML data retrieved from a web service that I use to create NSManagedObjects and store in a sqlite3 backing store. In my app, I'm using NSPredicate objects to query this data by date (along with other fields). The data I have has records for every day from April 2009 through August 2010 (according to the raw XML I retrieved ...

SQLite android NDK

I'm trying to use a custom function in sqlite3. I found no way in Java to do that so I moved on android-ndk, but now I'm having troubles integrating sqlite3 sources in my project. Compiler give me an error 'sqlite3_api' was note declared in this scope. In my source "sqlite3ext.h" is included (sqlite3 amalgamation is also included in...

storing double values in SQLite: how to ensure precision?

hi there! i have a problem with double values i need to store in an android homed sqlite database. since these double values represent gps values (lat & lng), i really NEED an absolute precision down to the 9th number after the comma. now i have a table like this: CREATE TABLE x REAL lng; and insert sth (hardcoded) like: INSERT INT...

efficient for querying large plists ?

I am planning to do search on large plists. say around 900 plists with data ranging from 120 to 250kb. which one is efficient for searching large plist ?? core data or sqlite ? ...

sqlite usages and propsure

Could someone provide an examples about why sqlite db is needed and for which propuses , especially if it can be used by security application ? ...

Can anyone provide a C# example of SQLite "SetTimeout"?

I'm using SQLite (system.data.sqlite v. 1.0.60.0) on a Fluent NHibernate project. I have one program that writes to the DB, and another that reads from it. Occasionally, I get SQLITE_BUSY exceptions, and I need to fix this. I found several Google references to sqlite_busy_timeout, which (if I understand correctly) will cause SQLite to...

Order by field with SQLite

Hello, I'm actually working on a Symfony project at work and we are using Lucene for our search engine. I was trying to use SQLite in-memory database for unit tests (we are using MySQL) but I stumbled upon something. The search engine part of the project use Lucene indexing. Basically, you query it and you get an ordered list of ids, w...

how to add xxx.db file into my project in android

i have xxx.db (SQLite file) where i want to add him to my android app in my android app under src i open new directory where i add "test.db" then in my app what should i write in order to get the db ? String myPath = "com.countryCityGame/databases/test.db"; SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY); i am...

How to Import data to SqLIte using Adobe Air

Hi, I am working on an Adobe Air project(using JavaScript and HTML). Users can install application and can enter customer details. The central server(PHP + MySQL) contains all the customer data and air applications sends customer data to that server and request for new data from the server. This process is working fine. But now I want o...

Android SQLite Cursor out of bounds exception on SELECT count(*) FROM table

Hi guys, The following function is giving me an out of bounds exception... public void count(){ SQLiteDatabase db = table.getWritableDatabase(); String count = "SELECT count(*) FROM table"; Cursor mcursor = db.rawQuery(count, null); int icount = mcursor.getInt(0); System.out.println("NUMBER IN DB: " + icount); } I...

Delete all rows from a table, throws nullpointer

Hi Guys, I'm trying to write a function that will delete every row in a given table but I'm getting a null pointer exception. Could somebody point me in the right direction? Here is the code... public void deleteall(){ SQLiteDatabase db = tweets.getWritableDatabase(); String delete = "TRUNCATE FROM tweets"; db.rawQuery(d...

Synchronizing sqlite database from memory to file

I'm writing an application which must log information pretty frequently, say, twice in a second. I wish to save the information to an sqlite database, however I don't mind to commit changes to the disk once every ten minutes. Executing my queries when using a file-database takes to long, and makes the computer lag. An optional solution...

Good embedded database for Qt?

I am looking for good embedded database that i can use for application developed using Qt. The applications target desktop users from various sites of a single large company. The database should be able to store data separately at each site and the data shall be merged with other sites as and when it is required. ...

SQLite Syntax (order by causing error)

Looking for some syntax help for SQLite, a very odd thing is happening. I am running the query on an iPhone. Here is the query that fails: (Assume that the tables are correct, this runs great in the firefox sqlite plugin) select tcodes.DisplayOrder, StatusText, StatusCode from tcodes join tcode_transitions on tcode_transi...

How to close and re-open Sqlite database?

In my app, I'm supporting the backup and restoration of the Sqlite db file. I need to close and re-open my database connection after the restore. How can I do this? ...

Problem creating SQLite trigger

Hi. I have a table called posts having an INT field posted and a table domains having field posted too, this one is supposed to be the sum of a posteds of posts belonging to a certain domain. Whether the post belongs to a domain is determined by a foreign domain_id in the table posts which links to the id in domains. I'm trying to create...