[sqlite] How to see SQLite debugging information

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

[sqlite] Making data unique

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

[sqlite] Making data unique

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 >

[sqlite] Making data unique

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

[sqlite] Bug with DATETIME('localtime')

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

[sqlite] maybe bug in regexp and replace with newlines?

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

[sqlite] build failure: undeclared identifier 'uintptr_h'

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

[sqlite] build failure: undeclared identifier 'uintptr_h'

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

[sqlite] build failure: undeclared identifier 'uintptr_h'

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

[sqlite] i think this is a bug in sqlite? thanks

https://github.com/rstats-db/RSQLite/issues/125#event-488337588

[sqlite] i think this is a bug in sqlite? thanks

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

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

> > 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