Re: [sqlite] what's wrong with this trigger

2019-09-09 Thread Igor Korot
Hi, On Mon, Sep 9, 2019 at 9:43 PM Doug wrote: > > What works, please? I saw no answer. There is an answer down below. Thank you. > Doug > > > -Original Message- > > From: sqlite-users > > On Behalf Of Rael Bauer > > Sent: Monday, September 09, 2019 7:01 PM > > To:

Re: [sqlite] SQLITE and the memory

2019-09-09 Thread Philippe RIO
The answer: I remember : I have 256 databases. I have an array of 256 columns into which I store the number of record created. When I insert a record into a table, the corresponding entry into this array is incremented by one. When this element is equal to 1000 I commit the transaction. Not all

Re: [sqlite] what's wrong with this trigger

2019-09-09 Thread Doug
What works, please? I saw no answer. Doug > -Original Message- > From: sqlite-users > On Behalf Of Rael Bauer > Sent: Monday, September 09, 2019 7:01 PM > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] what's wrong with this trigger > > Thanks, that works. > >

Re: [sqlite] what's wrong with this trigger

2019-09-09 Thread Rael Bauer
Thanks, that works. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] what's wrong with this trigger

2019-09-09 Thread Simon Slavin
On 10 Sep 2019, at 2:09am, Rael Bauer wrote: > CREATE TRIGGER notes_ai AFTER INSERT ON notes > BEGIN > update notebooks set notebooks.last_edit = datetime('now') > where notebooks.id = new.notebook_id; > END; > > SQLite Expert reports a near ".": syntax error. Is there something wrong with

[sqlite] what's wrong with this trigger

2019-09-09 Thread Rael Bauer
Hi, CREATE TABLE [notebooks] (   [id] INTEGER,   [last_edit] DATETIME); CREATE TABLE [notes](   [id] INTEGER,   [caption] VARCHAR,   [notebook_id] INTEGER); When a new note is added, I want to update the "last_edit" field for the notebook that this note belongs to. CREATE TRIGGER notes_ai

Re: [sqlite] SQLITE and the memory

2019-09-09 Thread Keith Medcalf
The Windows Task Manager shows various types of "memory usage" and that is different depending on how the wind blows at the moment. In fact, even the how the "name descriptions" given in the Windows Task Manager correspond to actual memory management values is subject to how the wind blows at

Re: [sqlite] SQLITE and the memory

2019-09-09 Thread Jens Alfke
> On Sep 8, 2019, at 2:12 PM, Philippe RIO <51...@protonmail.ch> wrote: > > I use the windows task manager to see how the memory is used I don't use Windows, but I know that in any modern OS, memory usage is a very vague thing and is tricky to measure. There are quite a few numbers that mean

[sqlite] 4th Call For Papers - Extended Deadline - 26th Annual Tcl/Tk Conference (Tcl'2019)

2019-09-09 Thread conference
Today is the original deadline for paper submissions. We are __extending__ this deadline_by one week, to __Sep 16, 2019, i.e. next Monday__. Hello SQLite Users, fyi ... 26th Annual Tcl/Tk Conference (Tcl'2019) https://www.tcl-lang.org/community/tcl2019/ November 05 - 08, 2019 Crowne Plaza