How To Use SQLite For Windows Phone7 Using Phonegap

Hi... I'm New To SQLite And Phone Gap so I need A clear And Step By Step Solution To My Problem. I"m Developing Windows Phone 7 Application Using Phone Gap version 2.9.0 . I need To Know Info Abou...

Id #1793 | Release: None | Updated: Oct 24, 2013 at 12:51 PM by Gurunathan3010 | Created: Oct 24, 2013 at 12:51 PM by Gurunathan3010

bug:crashes in ALTER TABLE

Example: "ALTER TABLE audio_book_setting ADD COLUMN download_hour INTEGER NOT NULL DEFAULT '0'".   The same code works perfectly fine on desktop Windows with System.Data.Sqlite.   It crashes on lin...

Id #1239 | Release: None | Updated: Feb 14, 2013 at 9:26 PM by johnqh | Created: May 26, 2012 at 12:39 AM by johnqh

bugfix: using LIKE with unicode character set

Summary: LIKE operator do not return any matches when either the data or the template contains characters codes bigger than 127.   How to reproduce: The following sequence of commands (with cyrilli...

Id #942 | Release: None | Updated: Aug 4, 2013 at 4:50 PM by zobeide | Created: Nov 30, 2011 at 11:37 PM by demosten

Please add method for last_insert_rowid

Please add a wrapper for last_insert_rowid:   public long LastInsertRowId() { return Sqlite3.sqlite3_last_insert_rowid(_db); }   Im using 0.6.1

Id #670 | Release: None | Updated: Apr 11, 2013 at 6:47 PM by tpalumbo | Created: Apr 16, 2011 at 9:06 PM by pivotnig

Reading a date generates an exception

Try to read data from a datetime column generates an exception in ToDateTime function - data comes in in "1/1/2011", which is not one of the supported formats.

Id #654 | Release: None | Updated: Feb 14, 2013 at 9:26 PM by SergeyBarskiy | Created: Apr 4, 2011 at 3:34 AM by SergeyBarskiy

Updating a record with >1 PK's

Hey, im getting an odd error when attempting to update a record with 2 primary keys. If I run the query in a normal SQLite browser it works fine but I get the following error in Wp7Sqlite:   System...

Id #638 | Release: None | Updated: Feb 14, 2013 at 9:26 PM by diligentpig | Created: Mar 15, 2011 at 2:01 PM by Workshop2

Make it threadsafe

Hi,   can you make the database connection threadsafe? I often get an exception because 2 or more threads are using the db connection at the same time.   Thanks, Buju

Id #619 | Release: None | Updated: Feb 14, 2013 at 9:26 PM by Buju | Created: Mar 4, 2011 at 12:20 PM by Buju

Debug Assertion

Hi, I'm using sqllite on WP7 app. There is a thread that polling a table fow new messages to send. The thread make a "select * from table where state=1" in a loop of 500ms each. in parallel I have ...

Id #618 | Release: None | Updated: Feb 14, 2013 at 9:26 PM by stefanob74 | Created: Feb 27, 2011 at 3:03 PM by stefanob74

  • 1-8 of 8 Work Items
    • Previous
    • 1
    • Next
    • Showing
    • All
    • Work Items