thanks Simon, stupidly I have used this, sqlite can be initialized using resource files. These can be combined with command line arguments to set up sqlite exactly the way you want it. Initialization proceeds as follows:
o The defaults of mode = LIST separator = "|" main prompt = "sqlite> " continue prompt = " ...> " found on http://www.linuxcommand.org/man_pages/sqlite31.html regards beppe On Sat, Aug 23, 2014 at 6:35 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Aug 2014, at 5:28pm, Giuseppe Costanzi <giuseppecosta...@gmail.com> > wrote: > >> my file, setconsole >> >> headers = ON >> mode = COLUMN >> timer = ON > > Those commands are dot commands, not proper SQLite commands. They need to > have dots in front of them. Also, having an equals sign there is incorrect. > Those lines should look more like > > .headers ON > .mode COLUMN > .timer ON > > If you are in doubt about a command try typing it into the SQLite shell tool > and see if it does what you want or gives you an error message. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users