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.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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

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