Re: [sqlite] Possible bug in FTS3 or Parametrization?

On 5 August 2011 14:55, Dan Kennedy wrote: > On 08/05/2011 05:44 PM, Martin Gill wrote: >> On 5 August 2011 10:55, Dan Kennedy  wrote: >>> >>> On 08/05/2011 02:58 PM, Martin Gill wrote: >>              SQLiteParameter param1 =

Re: [sqlite] Peculiar activity in an SQLite-using InDesign plug-in on the Macintosh

On 5 Aug 2011, at 4:34pm, john darnell wrote: > The problem is resolved. It turns out that I was calling a function to > save data to a child table. That function had a prepare statement that had > never been finalized. > > Though it's embarrassing to admit my dumb mistakes, I kinda

[sqlite] Text searching

We have an interesting problem here that has me at my wit's end - so, I thought I'd ask for advice. We have a list of words that we want to quickly search. We used FTS3 for it and it is fast and works very well. The only problem is that it breaks the original entry at word boundaries

Re: [sqlite] Peculiar activity in an SQLite-using InDesign plug-in on the Macintosh

> > Thanks for what help you gave. It pointed me in the right direction, I think. Simon: The problem is resolved. It turns out that I was calling a function to save data to a child table. That function had a prepare statement that had never been finalized. Though it's embarrassing

Re: [sqlite] Need Help! -- SQlite database on server

I'm reading about: http://www.atensoft.net/dev/sqlite3.php http://www.sqliteconcepts.org/CS_index.html http://www.sqlitening.com http://www.codeproject.com/KB/database/SQLite_Server.aspx http://www.realsoftware.com/realserver/ http://sqliteserver.xhost.ro/index.html http://users.libero.it/irwin/

Re: [sqlite] Possible bug in FTS3 or Parametrization?

On 08/05/2011 05:44 PM, Martin Gill wrote: > On 5 August 2011 10:55, Dan Kennedy wrote: >> >> On 08/05/2011 02:58 PM, Martin Gill wrote: >>> >>> CREATE VIRTUAL TABLE full_text USING FTS3 (id,text) >>> INSERT INTO full_text VALUES ('1', 'I have a foréign character.') >> >>

Re: [sqlite] Peculiar activity in an SQLite-using InDesign plug-in on the Macintosh

> > Not that I think they're the problem, but just for completeness, do some error > reporting on _initialize and _open and _prepare too. > > Simon. Sigh. I removed the error checking from the email because I am of the same opinion, and because I wanted to provide as simple a piece of code as

Re: [sqlite] Problem inserting empty Foreign Key in c++

Nikki Tan wrote: > I'm having problem inserting one record into a table that has Foreign Key > constraint, whereas I can succeed with the same SQL statement in command > line to the same table. My guess is, you are inserting empty strings in one case, and NULLs in the

[sqlite] Problem inserting empty Foreign Key in c++

Hi, I'm having problem inserting one record into a table that has Foreign Key constraint, whereas I can succeed with the same SQL statement in command line to the same table. Though I found I can bypass this problem by not including the FK in my c++ code at all. I'd still like to know the

Re: [sqlite] sqlite-users Digest, Vol 44, Issue 4

Another solution is to transfer ownership of the handle to the new object. E.g.: // Note that this requires the m_sqlite variable to be mutuable (for modification of const-object).DatabaseRecord::DatabaseRecord(const DatabaseRecord ){ m_sqlite = rhs.m_sqlite; ... rhs.m_sqlite

Re: [sqlite] sqlite-users Digest, Vol 44, Issue 4

> > -- > > Message: 4 > Date: Wed, 3 Aug 2011 16:25:13 +0200 > From: Stephan Beal > Subject: Re: [sqlite] Deep copy of 2 sqlite3*? > To: General Discussion of SQLite Database > Message-ID: >

Re: [sqlite] Possible bug in FTS3 or Parametrization?

On 5 August 2011 10:55, Dan Kennedy wrote: > > On 08/05/2011 02:58 PM, Martin Gill wrote: > > > > CREATE VIRTUAL TABLE full_text USING FTS3 (id,text) > > INSERT INTO full_text VALUES ('1', 'I have a foréign character.') > > SQLite does not recognize upper/lower-case

Re: [sqlite] Possible bug in FTS3 or Parametrization?

On 08/05/2011 02:58 PM, Martin Gill wrote: > Hi all > > I have discovered what may be a bug in either SQLLite or System.Data.SQLite > (v 1.0.66.0 using SQLite 3.6.23.1). I certainly don't understand what's > happening and I'd apprecite it if someone could help me out; perhaps I'm > missing

[sqlite] Possible bug in FTS3 or Parametrization?

Hi all I have discovered what may be a bug in either SQLLite or System.Data.SQLite (v 1.0.66.0 using SQLite 3.6.23.1). I certainly don't understand what's happening and I'd apprecite it if someone could help me out; perhaps I'm missing something. To recreate the issue create a database with the

Re: [sqlite] Need Help! -- SQlite database on server

Please take a look at cubeSQL: http://www.sqlabs.com/cubesql.php -- Marco Bambini http://www.sqlabs.com On Aug 4, 2011, at 7:15 PM, Vinoth raj wrote: > Dear SQLite users, > > I have been using SQlite database since three years. Suddenly I have a > requirement for client/server support

Re: [sqlite] Need Help! -- SQlite database on server

http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users