> 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
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
>
> 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
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.
Oops:
Sorry for the typo. I mean
"DROP TABLE IF EXISTS database_name.table_name"
--
Adolfo J. Millan
>
> 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
>
> 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
>
> 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
>>
>
> 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
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
> 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
>
> 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
> 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
>
>
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
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"
>
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
> 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
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
>
> 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
19 matches
Mail list logo
