Re: [sqlite] Problem with .mode line
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. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Problem with .mode line
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 the code: CREATE TABLE in one line - which is wrong !! :( :( :( -- View this message in context: http://sqlite.1065341.n5.nabble.com/Problem-with-mode-line-tp74045p74058.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Problem with .mode line
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] INTEGER NULL, [blah2] INTEGER NULL ); but when I do: .mode line .out file.txt .schema asd Result is: CREATE TABLE asd ([blah] INTEGER NULL,[blah2] INTEGER NULL); I am really depressed because I cannot pass such stupid issue for almost 2 weeks !! Looking forward for any help! thank you ! -- View this message in context: http://sqlite.1065341.n5.nabble.com/Problem-with-mode-line-tp74045.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users