[sqlite] Problem when upgrading from FTS3/4 to FTS5 modules (revisited)

2015-12-09 Thread a...@zator.com
Hi list: In a C++ Windows app that uses SQLite v. 3.9.1 and behaves well, I try change the search engine from FTS3/4 modules to FTS5, by means off: 1. Define the directive #define SQLITE_ENABLE_FTS5 1 2.- Create the table: CREATE VIRTUAL TABLE ftsm USING fts5(nm,tokenize='porter unicode61

[sqlite] Problem when upgrading from FTS3/4 to FTS5 modules(revisited)

2015-12-10 Thread a...@zator.com
> > Mensaje original > De: Dan Kennedy > Para: sqlite-users at mailinglists.sqlite.org > Fecha: Fri, 11 Dec 2015 02:41:43 +0700 > Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 to FTS5 > modules(revisited) > >> ... >> 1a.- Delete the previous table. >> DROP TABLE IF EXIST

[sqlite] Problem when upgrading from FTS3/4 to FTS5modules(revisited)

2015-12-11 Thread a...@zator.com
> > Mensaje original > De: Dan Kennedy > Para: sqlite-users at mailinglists.sqlite.org > Fecha: Fri, 11 Dec 2015 15:28:33 +0700 > Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 to > FTS5modules(revisited) > >> 1a.- Delete the previous table. >> DROP TABLE IF EXIST ftsm >>

[sqlite] Problem when upgrading from FTS3/4 toFTS5modules(revisited)

2015-12-13 Thread a...@zator.com
> > Mensaje original > De: Dan Kennedy > Para: sqlite-users at mailinglists.sqlite.org > Fecha: Fri, 11 Dec 2015 22:54:45 +0700 > Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 > toFTS5modules(revisited) > >>> 1a.- Delete the previous table. DROP TABLE IF EXIST

[sqlite] Problem when upgrading from FTS3/4 toFTS5modules(revisited)

2015-12-13 Thread a...@zator.com
> > Mensaje original > De: Dan Kennedy > Para: sqlite-users at mailinglists.sqlite.org > Fecha: Fri, 11 Dec 2015 22:54:45 +0700 > Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 > toFTS5modules(revisited) > > > >Are you able to compile a debugging build of SQLite and set a

[sqlite] Problem when upgrading from FTS3/4 toFTS5modules(revisited)

2015-12-13 Thread a...@zator.com
Oops: Sorry for the typo. I mean "DROP TABLE IF EXISTS database_name.table_name" -- Adolfo J. Millan

[sqlite] Problem when upgrading from FTS3/4 toFTS5modules(revisited)

2015-12-13 Thread a...@zator.com
I apologize for the mistake, but you must forget my last two posts (probably due the tiredness or the excitement of the moment). In fact, the query "DELETE TABLE IF EXIST database_name.table_name" goes flawlessly, but indeed does not drop the table. Sorry for the confusion. -- Adolfo J.

[sqlite] Problem when upgrading from FTS3/4toFTS5modules(revisited)

2015-12-15 Thread a...@zator.com
> > Mensaje original > De: Dan Kennedy > Para: sqlite-users at mailinglists.sqlite.org > Fecha: Mon, 14 Dec 2015 19:15:23 +0700 > Asunto: Re: [sqlite] Problem when upgrading from > FTS3/4toFTS5modules(revisited) > > > >So that looks like database corruption, except we don't think

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-15 Thread a...@zator.com
> Mensaje original > De: Scott Hess > Para: General Discussion of SQLite Database mailinglists.sqlite.org> > Fecha: Sun, 14 Jun 2015 10:10:24 -0700 > Asunto: Re: [sqlite] Mozilla wiki 'avoid SQLite' > While certainly, the thread has derived from the concept of the OP, and even some

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-18 Thread a...@zator.com
Indeed, I'm agree with Darren, and continuing its thought, perhaps that hypothetical new language would be a clean extensi?n of SQL in the same way that C++ was respect to C, simplifying the transition and reutilization of legacy code. Cheers. -- A.J. Millan > > Mensaje original >

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-18 Thread a...@zator.com
> Mensaje original > De: > Para: "'General Discussion of SQLite Database'" mailinglists.sqlite.org> > Fecha: Thu, 18 Jun 2015 14:50:40 +1000 > Asunto: Re: [sqlite] Mozilla wiki 'avoid SQLite' > Darren: Maybe you're right. But to that relationship of "goodness" that would be

[sqlite] Problem when upgrading from FTS3/4 to FTS5 modules

2015-11-04 Thread a...@zator.com
Hi list: Using SQLite 3.9.1, suppose a C++ application using FTS3/4 modules with this pseudocode: 1a In config.h #define SQLITE_ENABLE_FTS3 1 #define SQLITE_ENABLE_FTS3_PARENTHESIS 1 2a.- Delete the previous table if exist DROP TABLE IF EXISTS ftsm 3a.- Then create the table

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-11 Thread a...@zator.com
> Mensaje original > De: Richard Hipp > Para: General Discussion of SQLite Database mailinglists.sqlite.org> > Fecha: Tue, 10 Nov 2015 14:41:28 -0500 > Asunto: [sqlite] "Shipping a New Mindset" - SQLite in Windows 10 > >

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-11 Thread a...@zator.com
> > Mensaje original > De: Simon Slavin > Para: SQLite mailing list > Fecha: Wed, 11 Nov 2015 09:25:47 + > Asunto: Re: [sqlite] "Shipping a New Mindset" - SQLite in Windows 10 > >There's a story behind this. > >During the review leading to HTML5 the web consortium (the one

[sqlite] Problem when upgrading from FTS3/4 to FTS5 modules

2015-11-11 Thread a...@zator.com
> Mensaje original > De: Richard Hipp >Fecha: 4/11/2015 23:23 (GMT+01:00) >Para: SQLite mailing list >Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 to FTS5 modules >Here is a hack. >Let the name of your FTS3 table be "xyzzy" >(1) Invoke "PRAGMA writable_schema=ON". (Read

[sqlite] Erros using some compiler options for SQLite 3. and V. Studio 2015

2015-10-25 Thread a...@zator.com
Hi list: Using SQLite v.3.9.1 amalgamation code. MS Visual Studio 2015 for desktop C++ compiler I've got the same compiler error 1>sqlite3\sqlite3.c(x): fatal error C1017: expresi?n constante de tipo entero no v?lida in the following lines of sqlite3.c: #if SQLITE_ENABLE_FTS3

[sqlite] Erros using some compiler options for SQLite 3. and V. Studio 2015

2015-10-25 Thread a...@zator.com
rencia Perhaps the sentence #ifndef SQLITE_OMIT_TRACE must be moved up a couple lines Thanks again. -- Adolfo > > Mensaje original > De: "Keith Medcalf" > Para: "ajm at zator.com" , "General Discussion of SQLite > Database" >

[sqlite] SQLite remote access over WAN

2016-01-04 Thread a...@zator.com
Hi list: I've built a Windows desktop app using MS Visual C++ and SQLite. It works fair well in local mode, but now I need made it work over a TCP/IP network. My question is if some in this list can suggest a library to that purpose, on the basis that I have not concerns on questions like

[sqlite] SQLite remote access over WAN

2016-01-07 Thread a...@zator.com
> Mensaje original > De: Eduardo Morras > Para: sqlite-users at mailinglists.sqlite.org > Fecha: Mon, 4 Jan 2016 23:27:35 +0100 > Asunto: Re: [sqlite] SQLite remote access over WAN > >On Mon, 04 Jan 2016 22:52:56 +0100 >ajm at zator.com wrote: > &g