Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

Probably for the same reason people exceed 8.3 filename limitations on Windows or try to embed non-alphanumeric characters in file/directory names (Including spaces and shell special characters) -- they have been told that they could do so and not told of the problems and difficulties created

Re: [sqlite] adding two tables together

Thanks, Igor. On Thursday, January 22, 2015 4:23 PM, Igor Tandetnik wrote: On 1/22/2015 4:05 PM, Jose I. Cabrera wrote: >  imagine...create table t0 (a,b,c);insert into t0 values ('d','e','f');create >table t1 (a,b,c,de,e,f);insert into t1 values ('a','b','c',(select * from >t0)

Re: [sqlite] adding two tables together

On 1/22/2015 4:05 PM, Jose I. Cabrera wrote: imagine...create table t0 (a,b,c);insert into t0 values ('d','e','f');create table t1 (a,b,c,de,e,f);insert into t1 values ('a','b','c',(select * from t0));Error: table t1 has 6 columns but 4 values were supplied What I would like is to add t0 to t

[sqlite] adding two tables together

imagine...create table t0 (a,b,c);insert into t0 values ('d','e','f');create table t1 (a,b,c,de,e,f);insert into t1 values ('a','b','c',(select * from t0));Error: table t1 has 6 columns but 4 values were supplied What I would like is to add t0 to t1 so that t1 now hasa|b|c|d|e|f What would be th

Re: [sqlite] Huge WAL log

On 1/21/15, Jan Slodicka wrote: > > My suggestion to SQLite developers: > Please update the WAL documentation (namely the place where you warn > against > large transactions) by explaining potential risks. Thanks for the suggestion. I added some text here: https://www.sqlite.org/wal.html#b

[sqlite] [ANN] QxOrm 1.3.1 & QxEntityEditor 1.1.7 released

Hello, *QxOrm 1.3.1* (C++ Qt Object Relational Mapping library) and *QxEntityEditor 1.1.7* (the graphic editor) just released ! Changes in version *QxOrm 1.3.1*: * * New class qx::QxModelService in

Re: [sqlite] crash in sqlite3MatchSpanName

On 1/22/15, Michal Zalewski wrote: > Hey, > > Another afl-fuzz crash, looks like a straightforward NULL ptr deref, > 3.8.8.1: > > -- snip! -- > select e.*,0 from(s,(L))e; > -- snip! -- Thanks for the bug report. The fix is at https://www.sqlite.org/src/info/9e6eae660a0230 and the trouble-ticket

[sqlite] crash in sqlite3MatchSpanName

Hey, Another afl-fuzz crash, looks like a straightforward NULL ptr deref, 3.8.8.1: -- snip! -- select e.*,0 from(s,(L))e; -- snip! -- #0 sqlite3MatchSpanName (zSpan=0x0, zCol=0x0, zTab=0x6dce30 "e", zDb=0x0) at sqlite3.c:80494 #1 0x0047413c in selectExpander (pWalker=0x0, p=0x0) at sql

Re: [sqlite] excel vba use sqlite

Best way to do this is I think with this wrapper: http://www.vbrichclient.com/#/en/About/ It is very fast and has lots of other useful utilities other than SQLite, eg fast collection and dictionary classes. RBS On Thu, Jan 22, 2015 at 1:04 AM, YAN HONG YE wrote: > I don't know how to use sqlit