Re: [sqlite] Running sums and averages

2017-11-12 Thread Joseph R. Justice
On Nov 12, 2017 11:06 AM, "Balaji Ramanathan" wrote: Hi, I have a table (mytable) with several numerical fields. Let us call them F1, F2, etc., etc. The table also has a row number field (RowNumber) that I make sure has incremental values from 1 through the number of rows in the table.

Re: [sqlite] Update the SQLite package in Tcl

2017-11-19 Thread Joseph R. Justice
On Nov 18, 2017 1:22 PM, "Richard Hipp" wrote: On 11/18/17, Balaji Ramanathan wrote: > Hi, > > I have installed Tcl/Tk from a couple of places on the web (activetcl > and magicsplat), and I find that neither of them has the latest version of > sqlite3 as the standard sqlite3 package. Acti

Re: [sqlite] Update the SQLite package in Tcl

2017-11-19 Thread Joseph R. Justice
On Sun, Nov 19, 2017 at 4:49 PM, Keith Medcalf wrote: > On 19 November, 2017 10:50, Joseph R. Justice asked: > > >I'd think that dropping a newer version of SQLite, compiled as a run- > >time linkable library, into a pre-existing binary compiled to use a > >pre

Re: [sqlite] Update the SQLite package in Tcl

2017-11-19 Thread Joseph R. Justice
On Sat, Nov 18, 2017 at 1:06 PM, Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote: I have installed Tcl/Tk from a couple of places on the web (activetcl > and magicsplat), and I find that neither of them has the latest version of > sqlite3 as the standard sqlite3 package. ActiveTcl seem

Re: [sqlite] sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

2018-01-23 Thread Joseph R. Justice
On Jan 23, 2018 9:32 AM, "Richard Hipp" wrote: I'm still unable to reproduce this problem. I've tried on every 32-bit platform I have at hand: * Ubuntu with -m32 * Android * MacOS 10.6.8 with -m32 * MinGW (32-bit) on Win7 * MSVC (32-bit) on Win10 They all give the correct answe

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-27 Thread Joseph R. Justice
On Fri, Jan 27, 2017 at 7:49 PM, dandl wrote: > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of James K. Lowden > > >>>Sticking with C90 is perfectly rational if you're still running Windows > 98 on a Pentium III at 500 Mhz with 256 MB RAM. Else, really,

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

2014-01-20 Thread Joseph R. Justice
On Sat, Jan 18, 2014 at 3:38 PM, big stone wrote: And : > - python3.4 is still in beta also, not a released product. > - sadly first RC candidate 1 is February 9, 2014, 2 days earlier. > > Sqlite was so close now, *so close* to achieve this goal ... > Maybe you could get the Python devs to pu

Re: [sqlite] unique with icu

2014-10-25 Thread Joseph R. Justice
On Sat, Oct 25, 2014 at 3:44 PM, Richard Hipp wrote: > On Sat, Oct 25, 2014 at 7:09 AM, dd wrote: > > > Hi, > > > > icu enabled for sqlite. I didn't do any custom collations/like > operator. > > > > CREATE TABLE test(id integer primary key autoincrement, t text collate > > nocase, unique(t))