On May 16, 2017 7:32:41 PM EDT, "E.Pasma" <pasm...@concepts.nl> 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 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
The eval function is provided by an extension: <http://www.sqlite.org/cgi/src/artifact/f971962e92ebb8b0> -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users