On 1 Apr 2012, at 3:05am, John 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't see any
John 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 interpret/convert
> that
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 wo
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 SQLite
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 and left it opene
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.
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 ope
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 \"\" > mm.html");
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".
>
>
>
> system("echo >m
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 is choosing the correct q
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:
>
>
> not I wanted, how to wrie char in my html file?
This seems to be the code I sent you priva
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 mor
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 su
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.*" proje
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
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
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-users@sqlite.org
http://sqlite.org:8080/cg
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: s
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 anyo
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
>>> 3.7.10 2012-01-16 13:28:40 ebd01
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 ebd01a8deffb5024a5d7494eef800d2366d9720
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 ha
[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:
>
>
> not I wanted, how to wrie char in my html file?
That would create invalid html. "" will be displayed as
"" by the html p
23 matches
Mail list logo
