Re: [sqlite] PRAGMA foreign_keys = ?, feature request

2012-12-24 Thread Joe Mistachkin
Larry Brasfield wrote: Please do not take this as a gripe, but earlier, when I suspected that there might be a connection string solution, I did a search to see what the option name might be. I saw nothing at www.connectionstrings.com, http://system.data.sqlite.org in the doc, FAQ or

[sqlite] System.Data.SQLite .CHM [was: PRAGMA foreign_keys ...]

2012-12-24 Thread Larry Brasfield
Joe Mistachkin wrote: [regarding connection string options and a new open event in 1.0.83] These features are both documented in the System.Data.SQLite CHM help file (i.e. based on the embedded doc comments in the code). However, I can see how it might be difficult to find that information via

Re: [sqlite] System.Data.SQLite .CHM [was: PRAGMA foreign_keys ...]

2012-12-24 Thread Joe Mistachkin
Larry Brasfield wrote: Wow, a .CHM file! I did not even dream that it existed. Perhaps, instead of worrying about web-help, the top page at http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki could just have a link, labelled Documentation, leading to a page that says

[sqlite] insert return -1

2012-12-24 Thread Live Happy
i tried to insert this text : BEGIN:VCARD\nVERSION:2.1\nN:;okpl;;;\nFN:okpl\nTEL;CELL:034567895566\nTEL;HOME:885666\ nEMAIL;WORK:shs...@ghshhs.com\nEND:VCARD\n to my sqlite database in android but it return me -1 is there any special characters should change or replace wish some help and

Re: [sqlite] sqlite3.c:134542: warning: assignment from incompatible pointer type

2012-12-24 Thread Pavel Volkov
Hello. And, excuse my. 1. It is 3.7.15.1 (fossil tag: release) 2. It is trivial and self-documented. --- ext/rtree/sqlite3rtree.h.orig 2012-12-23 10:02:43.0 +0400 +++ ext/rtree/sqlite3rtree.h2012-12-23 10:03:43.0 +0400 @@ -47,7 +47,11 @@ struct sqlite3_rtree_geometry {

Re: [sqlite] insert return -1

2012-12-24 Thread Larry Brasfield
Live Happy wrote: i tried to insert this text : BEGIN:VCARD\nVERSION:2.1\nN:;okpl;;;\nFN:okpl\nTEL;CELL:034567895566\nTEL;HOME:885666\ nEMAIL;WORK:shsjhs at ghshhs.com\nEND:VCARD\n to my sqlite database in android but it return me -1 is there any special characters should change or replace

[sqlite] Multiple network connections

2012-12-24 Thread Çağlar Orhan
While i was reading *Using SQLite* from *Jay A. Kreibich*, i saw that sqlite doesn't designd for over network multiple client connections. I have a project that built on Microsoft .hta and vbscript. And I am using sqlite on the IIS for local storage but, 5 to 10 client applications connecting as a

Re: [sqlite] Multiple network connections

2012-12-24 Thread Larry Brasfield
Çağlar Orhan wrote: While i was reading *Using SQLite* from *Jay A. Kreibich*, i saw that sqlite doesn't designd for over network multiple client connections. I have a project that built on Microsoft .hta and vbscript. And I am using sqlite on the IIS for local storage but, 5 to 10 client