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:
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
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.
>
>
Thanks, that works.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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
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
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
> 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
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
9 matches
Mail list logo