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] 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

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

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