wt., 10 wrz 2019 o 04:43 Doug <dougf....@comcast.net> napisał(a):
> What works, please? I saw no answer.
> Doug
>
This:
wt., 10 wrz 2019 o 03:12 Simon Slavin <slav...@bigfraud.org> napisał(a):
> On 10 Sep 2019, at 2:09am, Rael Bauer <supp...@bauerapps.com> 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 the trigger syntax here, or is it some other problem?
>
> Some of the dots aren't needed. So try
>
> CREATE TRIGGER notes_ai AFTER INSERT ON notes
> BEGIN
> update notebooks set last_edit = datetime('now')
> where id = new.notebook_id;
> END;
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
wt., 10 wrz 2019 o 04:43 Doug <dougf....@comcast.net> napisał(a):
> What works, please? I saw no answer.
> Doug
>
> > -----Original Message-----
> > From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org>
> > 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.
> >
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-
> > users
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
