Re: [sqlite] Problem with .mode line

2014-02-26 Thread pelek
Thank you very much! was the problem ! I have replaced it with the "\n" and now it works great !! -- View this message in context: http://sqlite.1065341.n5.nabble.com/Problem-with-mode-line-tp74045p74125.html Sent from the SQLite mailing list archive at Nabble.com. ___

Re: [sqlite] Problem with .mode line

2014-02-21 Thread RSmith
On 2014/02/20 16:58, pelek wrote: indeed ! I tried to open same file with Programers Notepad and file looked exacly like I need. But when I was opening file in standard windows notepad then I got whole CREATE TABLE code in one line! It is problem for me, because I am trying to open same file wit

Re: [sqlite] Problem with .mode line

2014-02-21 Thread mm.w
hello, this is only a problem of carriage returns or/and line feed. http://notepad-plus-plus.org/ Best Regards. On Thu, Feb 20, 2014 at 6:58 AM, pelek wrote: > indeed ! I tried to open same file with Programers Notepad and file looked > exacly like I need. But when I was opening file in sta

Re: [sqlite] Problem with .mode line

2014-02-21 Thread pelek
indeed ! I tried to open same file with Programers Notepad and file looked exacly like I need. But when I was opening file in standard windows notepad then I got whole CREATE TABLE code in one line! It is problem for me, because I am trying to open same file with c# code. Unfortunetly c# is opening

Re: [sqlite] Problem with .mode line

2014-02-20 Thread Clemens Ladisch
pelek wrote: > CREATE TABLE asd ( > [blah] INTEGER NULL, > [blah2] INTEGER NULL > ); > > .mode line > .out file.txt > .schema asd > > Result is: > CREATE TABLE asd ([blah] INTEGER NULL,[blah2] INTEGER NULL); Works for me. (In an editor that understands Unix line endings). I don't know why the sh