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 saving
the mail message as a text file and taking that in the editor two
become an sql script. This apparently leaves some two-byte spaces,
causing this humanly invisable error.
How to fix this in VI I don't know.
Downloading the text by simple copy and paste cures fixed the problem.
The procedure works great and can easily be customized.
I'd generate a temporary view as one must not be tempted to keep it
(and miss new fruits).
Thanks, E. Pasma
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users