>
> 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
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
> build:
>
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.
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Anthony
Damico
Sent: Thursday, December
https://github.com/rstats-db/RSQLite/issues/125#event-488337588
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.
RBS
On Thu, Dec 10, 2015 at 10:19 AM, Simon Slavin wrote:
>
> On 10 Dec 2015, at 10:17am, Bart Smissaert
> wrote:
>
> > 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
>> build:
>>
>
> Should be fixed now. Please try again.
Well done! Thanks.
--
---
inum: 883510009027723
sip: jungleboogie
Hello,
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.
Regards
David M Bennett FACS
12 matches
Mail list logo