> 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
>> 1a.- Delete the previous table.
>> DROP TABLE IF EXIST
On 12/2/2015 7:54 AM, michael wrote:
>>/sqlite3 -header flexsql.db "select distinct replace(lower(text),0x0A,'')
>>/>>/from v_term_item where lower(text) REGEXP('.*some_text.*') limit 1;" /
>You are removing newlines in the wrong spot. Do it on the left-hand side
>of REGEXP, not in SELECT
On 12/10/15, jungle Boogie wrote:
> Updating to trunk this morning results in this failure when attempting to
Should be fixed now. Please try again.
D. Richard Hipp
drh at sqlite.org
I was about the suggest the same thing that was suggest in that thread. Verify
the types of those values.
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Anthony
Sent: Thursday, December
Ah, yes they both work and tell me the indexed fields.
Saves me some work parsing this out from the table create SQL.
Thanks for that.
On Thu, Dec 10, 2015 at 10:19 AM, Simon Slavin wrote:
> On 10 Dec 2015, at 10:17am, Bart Smissaert
> > This will show in sqlite_master like
On 10 Dec 2015, at 10:17am, Bart Smissaert wrote:
> This will show in sqlite_master like this:
> type name tbl_name rootpage sql
> index sqlite_autoindex_dataset_1 dataset 717
This will show in sqlite_master like this:
type name tbl_name rootpage sql
index sqlite_autoindex_dataset_1 dataset 717
So, no SQL. Problem with this is that there is no way to see
On 10 December 2015 at 10:00, Richard Hipp wrote:
> On 12/10/15, jungle Boogie wrote:
>> Updating to trunk this morning results in this failure when attempting to
> Should be fixed now. Please try again.
Well done! Thanks.
Updating to trunk this morning results in this failure when attempting to build:
% ./configure --disable-editline
G_H -DBUILD_sqlite -DNDEBUG -I/usr/local/include/tcl8.6
-DSQLITE_THREADSAFE=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c -o sqlite3.o
sqlite3.c:21951:9: error: use of undeclared
In both cases the conversion is only correct when it is correct. Microsoft is
a teeny weeny company that exists and does business only in one time zone and
has existed for such a short period of time (and produces software which covers
such short periods of time) that they have never ever
On Windows you will get a console and standard output if you are running a
console application, and otherwise not.
I think you need a simple console app to call your ActiveX DLL, or find some
other way. Windows GUI app and standard output do not play well together.
David M Bennett FACS
Mail list logo