"Giuseppe Costanzi" wrote...
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
That man page is a little outdated. It used SQLite version 3.0.8 and its
date at the bottom is
Mon Apr 15 23:49:17 2002 SQLITE(1)
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users