Re: [sqlite] Importing date string 'YYYYMMDD'

On 1 Apr 2012, at 3:05am, John <li...@jspect.fastmail.fm> wrote: > Can the date time functions in SQLite correctly interpret a date string like > '20120331'? Is there a format or modifier that will help the function > interpret/convert that as '2012-03-31'? > > I don'

Re: [sqlite] Importing date string 'YYYYMMDD'

John <li...@jspect.fastmail.fm> wrote: > Can the date time functions in SQLite correctly interpret a date string > like '20120331'? No. Recognized formats are documented here: http://sqlite.org/lang_datefunc.html > Is there a format or modifier that will help the function in

[sqlite] Importing date string 'YYYYMMDD'

Hi Can the date time functions in SQLite correctly interpret a date string like '20120331'? Is there a format or modifier that will help the function interpret/convert that as '2012-03-31'? I don't see anything myself at the moment but thought I should ask before working out other solutions

[sqlite] System.Data.SQLite version 1.0.80.0 released

System.Data.SQLite version 1.0.80.0 (with SQLite 3.7.11) is now available on the System.Data.SQLite website: http://system.data.sqlite.org/ Further information about this release can be seen at http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the

Re: [sqlite] Bug - Aborted statement by a nested savepoint

On Sat, Mar 31, 2012 at 12:07 PM, Lukas Gebauer wrote: > Hi all! > > Sqlite version 3.7.11 on Windows cause error in my program. Some of my > pending statements are aborted by a nested savepoint transaction. See: > > SAVEPOINT x1; > SELECT * FROM sometable; //just open statement

Re: [sqlite] [patch] sqlite-3.7.11: valgrind errors in testsuite

Dan Kennedy wrote: > On 03/31/2012 04:04 PM, Yuriy Kaminskiy wrote: >> valgrind ./testfixture test/trigger7.test >> >> Note: line numbers below are off-by-2. >> >> trigger7-2.1... Ok >> trigger7-2.2...==11533== Invalid read of size 1 >> >> Seems always reproducible. > > Thanks for reporting this.

[sqlite] Bug - Aborted statement by a nested savepoint

Hi all! Sqlite version 3.7.11 on Windows cause error in my program. Some of my pending statements are aborted by a nested savepoint transaction. See: SAVEPOINT x1; SELECT * FROM sometable; //just open statement and left it opened! SAVEPOINT x2; RELEASE x2; ... call sqlite3_step on previously

Re: [sqlite] about sqlite3_exec function

Arrrgghhh...that's what I get for coding off the top of my head. As somebody else pointed out Window escapes are different than Unix. So these work (and have been tested now on Windows XP and Redhat). Windows main() { system("echo ^ >mm.html"); } Unix system("echo \"\" >

Re: [sqlite] about sqlite3_exec function

On 31 Mar 2012, at 12:48pm, "Black, Michael (IS)" wrote: > What you want is the system() function which will execute a shell command. > > > > But you still need to add your own HTML around it to be displayed by a > browser as it's missing the "rest of the story". >

Re: [sqlite] covering indices are preferred over indices covering more terms in a join

On Fri, Mar 30, 2012 at 9:42 AM, Reinco Hof wrote: > Hello, > > > > I would like to report a sqlite problem: > > > > Covering indices are preferred over indices covering more terms in a join. > > This leads to a suboptimal query plan. > I think that in this case, SQLite

Re: [sqlite] how to wrie "" char in my html file?

On Sat, Mar 31, 2012 at 2:55 AM, YAN HONG YE wrote: >>sqlite3 -html C:\mydatabase\mydzh.db "select ''">mm.html > this command result is not in the mm.html file, it's this following > text: > table > > not I wanted, how to wrie char in my html file? This seems to be the

[sqlite] covering indices are preferred over indices covering more terms in a join

Hello,   I would like to report a sqlite problem:   Covering indices are preferred over indices covering more terms in a join. This leads to a suboptimal query plan.   In the example below index idx_tableB_full is used instead of idx_tableB_partial, even though the partial index covers

Re: [sqlite] about sqlite3_exec function

What you want is the system() function which will execute a shell command. But you still need to add your own HTML around it to be displayed by a browser as it's missing the "rest of the story". system("echo >mm.html"); // first one creates mm.html system("echo >>mm.html"); // 2nd and

Re: [sqlite] System.Data.SQLite

J Decker wrote: > > '1>LINK : fatal error LNK1181: cannot open input file > 'M:\clapps\xperdex\SQLite\1.0.79.0\SQLite.Interop\..\bin\2010\DebugModule\bi n\System.Data.SQLite.netmodule'' > In your new solution, the "SQLite.Interop.*" project(s) should have the "System.Data.SQLite.Module.*"

Re: [sqlite] [patch] sqlite-3.7.11: valgrind errors in testsuite

On 03/31/2012 04:04 PM, Yuriy Kaminskiy wrote: valgrind ./testfixture test/trigger7.test Note: line numbers below are off-by-2. trigger7-2.1... Ok trigger7-2.2...==11533== Invalid read of size 1 Seems always reproducible. Thanks for reporting this. These tests are run with valgrind as part

[sqlite] Typo in documentation

Hello! I just found a typo in http://www.sqlite.org/fileformat.html Search for "stored with the must significant byte first" that should read: "stored with the most significant byte first". A one letter typo, no big deal. -- Barbu Paul - Gheorghe Common sense is not so common - Voltaire Visit

Re: [sqlite] how to wrie "" char in my html file?

On 31 Mar 2012, at 7:55am, YAN HONG YE wrote: > how to wrie char in my html file? In Unix, echo '' >> mm.html In Windows it is something like echo ' >> mm.html Simon. ___ sqlite-users mailing list

[sqlite] [patch] sqlite-3.7.11: valgrind errors in testsuite

valgrind ./testfixture test/trigger7.test Note: line numbers below are off-by-2. trigger7-2.1... Ok trigger7-2.2...==11533== Invalid read of size 1 ==11533==at 0x401FD90: memcpy (mc_replace_strmem.c:482) ==11533==by 0x8098EE2: sqlite3VdbeMemGrow (vdbemem.c:90) ==11533==by 0x80CD503:

[sqlite] updating config.guess and config.sub

Hi, while compiling for Android, I ran into the issue where arm-linux-androideabi is not recognized as a host. Apparently there is an updated version of config.guess and config.sub (from AutoTools) that addresses this issue. Recommend an update of these two files in the next version. In case

Re: [sqlite] Crash (c0000005 - Access Violation) in sqlite3.exe

Yuriy Kaminskiy wrote: > Richard Hipp wrote: >> On Thu, Feb 23, 2012 at 12:29 PM, Petite Abeille >> wrote: >> >>> On Feb 23, 2012, at 6:21 PM, Levi Haskell wrote: >>> sqlite> select 1 from (select *); >>> Wow, wicked :) >>> >>> Confirmed on sqlite3 -version >>>

Re: [sqlite] Crash (c0000005 - Access Violation) in sqlite3.exe

Richard Hipp wrote: > On Thu, Feb 23, 2012 at 12:29 PM, Petite Abeille > wrote: > >> On Feb 23, 2012, at 6:21 PM, Levi Haskell wrote: >> >>> sqlite> select 1 from (select *); >> Wow, wicked :) >> >> Confirmed on sqlite3 -version >> 3.7.10 2012-01-16 13:28:40

Re: [sqlite] Crash in icuOpen()

On Fri, Mar 30, 2012 at 07:38:11PM -0400, Richard Hipp wrote: > It is easy enough for use to just put a patch in the code to fix this. But > we would rather understand what is happening first. Can you recreate the > problem? Can you give us any clues what you are doing in order to make > this

Re: [sqlite] how to wrie "" char in my html file?

[YAN HONG YE] >>sqlite3 -html C:\mydatabase\mydzh.db "select ''">mm.html > this command result is not in the mm.html file, it's this following > text: > table > > not I wanted, how to wrie char in my html file? That would create invalid html. "table" will be displayed as "" by the html

[sqlite] how to wrie "" char in my html file?

>sqlite3 -html C:\mydatabase\mydzh.db "select ''">mm.html this command result is not in the mm.html file, it's this following text: table not I wanted, how to wrie char in my html file? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] about sqlite3_exec function

[YAN HONG YE] > sqlite3_exec( db, "???", 0, 0, ); > > I wanna add this following command into sqlite3_exec func: > "sqlite3 -html -header mydzh.db \"select * from dhq where ph15>10;\" >mm.html" > like this: > sqlite3_exec( db, "-html -header \"select * from dhq where ph15>10;\" > >mm.html", 0,