Re: [sqlite] Generalized SQLite stored procedure style pivot table exhibit.

It just occurred to me that I didn't completely finish my thought in the earlier reply. The suggested pivot views synchronization TRIGGER is named quarterly_sales_fruit_insert instead of simply quarterly_sales_insert for a specific reason. There is no need to regenerate pivot views unless the

Re: [sqlite] SAVEPOINT with multiple databases

Oh, now i understand. Thank you, Simon. Roman Original message From: Simon Slavin Date: 5/16/17 5:35 PM (GMT-05:00) To: SQLite mailing list Subject: Re: [sqlite] SAVEPOINT with multiple databases On 16 May

Re: [sqlite] Generalized SQLite stored procedure style pivot table exhibit.

Some text presentation software may be sensitive to the necessary quote escaping regime. In this case, double single quotes are necessary to escape interior single quotes of the nested literals. Perhaps one or both, mine or yours, email client(s) is producing an undesired transformation of

[sqlite] sqlite3_create_function xFinal argument called when there's an error?

All- for aggregate functions, is xFinal called if there's an error? For example, in the percentile.c add-on function, percentStep has code like sqlite3_result_error(pCtx, "2nd argument to percentile() is not " "a number between 0.0 and 100.0", -1); If that error

Re: [sqlite] SAVEPOINT with multiple databases

On 16 May 2017, at 10:09pm, Roman Fleysher wrote: > I think I came to a point where I need to learn SAVEPOINTs. > > I am trying to understand documentation if creation and release of save > points covers all presently attached databases, that is those before

[sqlite] SAVEPOINT with multiple databases

Dear SQLiters, I think I came to a point where I need to learn SAVEPOINTs. I am trying to understand documentation if creation and release of save points covers all presently attached databases, that is those before save point is created? Is attaching a database just a command that will sit on

Re: [sqlite] Generalized SQLite stored procedure style pivot table exhibit.

15 mei 2017, 07:34 petern: Here I revisit the pivot table problem using the SQLite stored procedure pattern and pure unmodified SQLite. I am seeking feedback for improving the brevity of the stored procedure presented here. Hi, initially I got: near "eval": syntax error. This is after

Re: [sqlite] Generalized SQLite stored procedure style pivot table exhibit.

On May 16, 2017 7:32:41 PM EDT, "E.Pasma" wrote: >15 mei 2017, 07:34 petern: > >> Here I revisit the pivot table problem using the SQLite stored >> procedure >> pattern and pure unmodified SQLite. I am seeking feedback for >> improving >> the brevity of the stored