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 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

[sqlite] Problem with .mode line

2014-02-20 Thread pelek
Hello, I am using sqlite3's shell command program to update my DB. Now something really funny is happening. I am using code to create table: CREATE TABLE asd ( [blah] INTEGER NULL, [blah2] INTEGER NULL ); Then I am doing: .mode line .out stdout .schema asd Result is: CREATE TABLE asd ( [blah]