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:
| Updated: Oct 24, 2013 at 12:51 PM by Gurunathan3010 | Created: Oct 24, 2013 at 12:51 PM by Gurunathan3010
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:
| Updated: Feb 14, 2013 at 9:26 PM by johnqh | Created: May 26, 2012 at 12:39 AM by johnqh
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:
| Updated: Aug 4, 2013 at 4:50 PM by zobeide | Created: Nov 30, 2011 at 11:37 PM by demosten
Please add a wrapper for last_insert_rowid:
public long LastInsertRowId()
Im using 0.6.1
Id #670 | Release:
| Updated: Apr 11, 2013 at 6:47 PM by tpalumbo | Created: Apr 16, 2011 at 9:06 PM by pivotnig
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:
| Updated: Feb 14, 2013 at 9:26 PM by SergeyBarskiy | Created: Apr 4, 2011 at 3:34 AM by SergeyBarskiy
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:
Id #638 | Release:
| Updated: Feb 14, 2013 at 9:26 PM by diligentpig | Created: Mar 15, 2011 at 2:01 PM by Workshop2
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.
Id #619 | Release:
| Updated: Feb 14, 2013 at 9:26 PM by Buju | Created: Mar 4, 2011 at 12:20 PM by Buju
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:
| Updated: Feb 14, 2013 at 9:26 PM by stefanob74 | Created: Feb 27, 2011 at 3:03 PM by stefanob74