Re: [sqlite] SQLite output mode

2017-01-26 Thread Michael Falconer 
Just from some quick command line tool playing around, a dirt quick fix
presented itself. .mode csv followed by .mode column (following the .mode
ascii operation) seems to return the .column mode to normal. This on SQLite
3.16.2 on Linux command line. I'm not suggesting this as a fix as Dr Hipp
has already attended to that but I found it interesting anyway.



On 27 January 2017 at 12:54, Richard Hipp  wrote:

> On 1/26/17, Nikolas Manes  wrote:
> > Hello,
> > I am Nikolas and facing an issue with sqlite, could you please help?
> > You will find more details on the link bellow.
> > http://stackoverflow.com/q/41730574/6293866
>
> The ".mode ascii" command changes the default row and column separators.
>
> Check-in https://www.sqlite.org/src/info/58f02e6eae8fc9e2 enhances the
> command-line shell to change the row and column separator strings back
> to the default when you do ".mode column".  This enhancement will
> appear in the next release.  Or you can recompile using the code on
> trunk, which is stable.
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Regards,
 Michael.j.Falconer.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite output mode

2017-01-26 Thread Richard Hipp 
On 1/26/17, Nikolas Manes  wrote:
> Hello,
> I am Nikolas and facing an issue with sqlite, could you please help?
> You will find more details on the link bellow.
> http://stackoverflow.com/q/41730574/6293866

The ".mode ascii" command changes the default row and column separators.

Check-in https://www.sqlite.org/src/info/58f02e6eae8fc9e2 enhances the
command-line shell to change the row and column separator strings back
to the default when you do ".mode column".  This enhancement will
appear in the next release.  Or you can recompile using the code on
trunk, which is stable.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite output mode

2017-01-26 Thread Simon Slavin 

On 26 Jan 2017, at 8:34pm, Nikolas Manes  wrote:

> I am Nikolas and facing an issue with sqlite, could you please help?
> You will find more details on the link bellow.
> http://stackoverflow.com/q/41730574/6293866
> * Please post your answer to Stack Overflow.

No.  I have no Stack Overflow account.

You can post your message here.  Include all the commands necessary to recreate 
your problem: the CREATE TABLE and INSERT commands, then the command which 
gives the unexpected results.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite output mode

2017-01-26 Thread Nikolas Manes 
Hello,
I am Nikolas and facing an issue with sqlite, could you please help?
You will find more details on the link bellow.
http://stackoverflow.com/q/41730574/6293866
* Please post your answer to Stack Overflow.
Thank you,
Nikolas.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users