Re: [sqlite] error installing (design support) for v1.0.78.0

2012-01-27 Thread Joe Mistachkin
Levi Haskell wrote: > > I downloaded v1.0.78.0 bundle for Framework 3.5 (tried both 32bit and 64bit, > my machine is x64). During the installation of design-time supoort (as part > of the main installation) I get the following error: > This issue was reported earlier today as well. It has been

[sqlite] error installing (design support) for v1.0.78.0

2012-01-27 Thread Levi Haskell
Hi, I downloaded v1.0.78.0 bundle for Framework 3.5 (tried both 32bit and 64bit, my machine is x64). During the installation of design-time supoort (as part of the main installation) I get the following error: System.Data.SQLite Designer Installer --- could not open

Re: [sqlite] Newbie stumper

2012-01-27 Thread Pavel Ivanov
>> select typeof(max(id)) from categories  -- returns 'null' >> select case max(id) when null then 1 end as NextID from categories > > Matching with "null" does not work the same as matching with other values. > "null" means "I don't know." so every value matches with it. Just the opposite - every

Re: [sqlite] Newbie stumper

2012-01-27 Thread Petite Abeille
On Jan 27, 2012, at 8:43 PM, K Peters wrote: > Why would the second statement still return null if the first statements > returns 'null'? > > > select typeof(max(id)) from categories -- returns 'null' > select case max(id) when null then 1 end as NextID from categories As mentioned, null is,

Re: [sqlite] Newbie stumper

2012-01-27 Thread Jay A. Kreibich
On Fri, Jan 27, 2012 at 11:43:00AM -0800, K Peters scratched on the wall: > Hi, > > when my categories table is empty: > > Why would the second statement still return null if the first statements > returns 'null'? Three value logic.NULL != NULL -j -- Jay A. Kreibich < J A Y @ K R

Re: [sqlite] Newbie stumper

2012-01-27 Thread Simon Slavin
On 27 Jan 2012, at 7:43pm, K Peters wrote: > Why would the second statement still return null if the first statements > returns 'null'? > > > select typeof(max(id)) from categories -- returns 'null' > select case max(id) when null then 1 end as NextID from categories Matching with "null" does

[sqlite] Newbie stumper

2012-01-27 Thread K Peters
Hi, when my categories table is empty: Why would the second statement still return null if the first statements returns 'null'? select typeof(max(id)) from categories -- returns 'null' select case max(id) when null then 1 end as NextID from categories Thanks for all help, Kai ___

Re: [sqlite] date function

2012-01-27 Thread Bill McCormick
Bill McCormick wrote, On 1/27/2012 12:12 PM: I have a date stored in a numeric field like this: 2012-01-27 16:47:50. I want to update the date using the date function, like this: update table set TIME_STAMP = date('TIME_STAMP', '+ 2 years'); Reference: http://www.sqlite.org/lang_datefunc.html

Re: [sqlite] [bugreport] Comments in views can result in broken backups

2012-01-27 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26/01/12 06:17, Dmitry Astapov wrote: > Comments in views could result in broken database dumps. The underlying cause is as you said. When SQL text is stored in sqlite_master, trailing whitespace is removed. The text for tables, indices and trigg

Re: [sqlite] date function

2012-01-27 Thread Richard Hipp
On Fri, Jan 27, 2012 at 1:12 PM, Bill McCormick wrote: > I have a date stored in a numeric field like this: 2012-01-27 16:47:50. > > I want to update the date using the date function, like this: > > update table set TIME_STAMP = date('TIME_STAMP', '+ 2 years'); > > Reference: > http://www.sqlite.

[sqlite] date function

2012-01-27 Thread Bill McCormick
I have a date stored in a numeric field like this: 2012-01-27 16:47:50. I want to update the date using the date function, like this: update table set TIME_STAMP = date('TIME_STAMP', '+ 2 years'); Reference: http://www.sqlite.org/lang_datefunc.html I also tried this: update table set TIME_STAM

Re: [sqlite] sqlite-users Digest, Vol 49, Issue 27

2012-01-27 Thread Igor Tandetnik
On 1/27/2012 12:13 PM, Pete wrote: I think you misunderstood my question. I simply want to run sqlite3 on Windows to create a database and use it's other functionality, not call it from another application. My question is simply what is the conventional place to put it on a Windows computer.

Re: [sqlite] sqlite-users Digest, Vol 49, Issue 27

2012-01-27 Thread Pete
I think you misunderstood my question. I simply want to run sqlite3 on Windows to create a database and use it's other functionality, not call it from another application. My question is simply what is the conventional place to put it on a Windows computer. Pete > Message: 10 > Date: Thu, 26 J

[sqlite] [$db incrblob] and asynchronous [chan copy]

2012-01-27 Thread Andy Goth
http://wiki.tcl.tk/2633#pagetoc0d507ec9 AMG: I can't seem to get asynchronous [chan copy] to work with [$db incrblob]. Synchronous works just fine, but when I do asynchronous, the copy never starts. I'm copying from the incrblob to a network socket. (Someday I might also copy from a network so

Re: [sqlite] SQLite and Perl

2012-01-27 Thread Bill McCormick
Darren Duncan wrote, On 1/27/2012 1:41 AM: Puneet Kishor wrote: On Jan 26, 2012, at 2:53 PM, Bill McCormick wrote: Puneet Kishor wrote, On 1/26/2012 12:02 PM: $ cpanm DBD::SQLite there is no step two Actually, that's not correct. In my case it took the following: Step 1: cpan DBI Step 2: c

Re: [sqlite] SQL query causes various hangs/crashes/exits

2012-01-27 Thread Stephen C
One of the things I try to maintain when writing databases is that whenever I start poking at a field with WHERE, said field gets an index to its own, and then I leave it to the engine of choice (SQLite, MSSql, MySQL) to decide to use the indexes. I have rarely been let down performance wise.

[sqlite] [bugreport] Comments in views can result in broken backups

2012-01-27 Thread Dmitry Astapov
Sqlite3 version 3.7.7.1 2011-06-28 17:39:05 af0d91adf497f5f36ec3813f04235a6e195a605f Comments in views could result in broken database dumps. Consider broken-backup.sql (that sets up a toy db) and broken-backup.sh (that illustrates the bug): === broken-backup.sql === create table a (int); create

[sqlite] System.Data.SQLite version 1.0.78.0 released

2012-01-27 Thread Joe Mistachkin
System.Data.SQLite version 1.0.78.0 (with SQLite 3.7.10) 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

Re: [sqlite] SQL query causes various hangs/crashes/exits

2012-01-27 Thread Mohit Sindhwani
Hello... On 27/1/2012 3:20 AM, Larry Knibb wrote: On 25 January 2012 21:01, Igor Tandetnik wrote: This index can help satisfy conditions of the form (traditional='X') or (traditional='X' AND simplified='Y'). But it doesn't help at all for conditions on (simplified='Y') or (traditional='X' O

Re: [sqlite] sqlite.net download file

2012-01-27 Thread Joe Mistachkin
majorthorb...@mst-it-services.info wrote: > > C:\Program Files\System.Data.SQLite\2010\GAC>"..\..\..\microsoft > sdks\windows\v7 > .1\bin\gacutil" /i System.Data.SQLite.dll > Microsoft (R) .NET Global Assembly Cache Utility. Version 3.5.30729.1 > Copyright (c) Microsoft Corporation. All rights r

Re: [sqlite] sqlite.net download file

2012-01-27 Thread majorthorburn
Installed latest SDK (7.1) and reran the command and got the following: C:\Program Files\System.Data.SQLite\2010\GAC>"..\..\..\microsoft sdks\windows\v7 .1\bin\gacutil" /i System.Data.SQLite.dll Microsoft (R) .NET Global Assembly Cache Utility. Version 3.5.30729.1 Copyright (c) Microsoft Corporat

Re: [sqlite] sqlite3_bind_text data conversion

2012-01-27 Thread darkelf
Hello, Simon. You wrote Thursday, January 26, 2012, 07:37:19: >> rez = sqlite3_exec(ss_pdb, "CREATE TABLE T(str STRING, val INTEGER);", NULL, >> NULL, NULL); > > Datatypes in SQLite are as follows: > > http://www.sqlite.org/datatype3.html > > Your word 'STRING' is being interpreted as a numeric