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 <[email protected]> wrote:
>
> On 23 Aug 2014, at 5:28pm, Giuseppe Costanzi <[email protected]>
> 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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
