Re: [sqlite] Unnecessary line breaks in .dump output

2009-03-31 Thread P Kishor
On Tue, Mar 31, 2009 at 5:46 AM, Francois Botha wrote: >> >> Perhaps the OP should file a ticket to have this corrected >> in the SQLite command line tool. >> > > What's the OP?  Just want to know if I must log the bug or whether you're > referring to somebody else. > >

Re: [sqlite] Unnecessary line breaks in .dump output

2009-03-31 Thread Francois Botha
> > Perhaps the OP should file a ticket to have this corrected > in the SQLite command line tool. > What's the OP? Just want to know if I must log the bug or whether you're referring to somebody else. If the OP is somebody else, please log it and let me know what the ticket number is so that I

Re: [sqlite] Unnecessary line breaks in .dump output

2009-03-28 Thread Francois Botha
> > > Attachments don't make it through the mailing list, > Uhm, sorry. I'm new here. I don't want to paste the SQL script in an email, because it contains line breaks and I don't want the formatting to change during email transport. Try www.vwd.co.za/sqlitedump.zip regards, Francois

Re: [sqlite] Unnecessary line breaks in .dump output

2009-03-27 Thread Simon Davies
2009/3/27 Simon Davies : > 2009/3/27 Francois Botha : >> >> Uhm, sorry. I'm new here.  I don't want to paste the SQL script in an email, >> because it contains line breaks and I don't want the formatting to change >> during email

Re: [sqlite] Unnecessary line breaks in .dump output

2009-03-27 Thread Simon Davies
2009/3/27 Francois Botha : > (my apologies if this is a duplicate) > > >> Attachments don't make it through the mailing list, >> > > Uhm, sorry. I'm new here.  I don't want to paste the SQL script in an email, > because it contains line breaks and I don't want the

[sqlite] Unnecessary line breaks in .dump output

2009-03-27 Thread Francois Botha
(my apologies if this is a duplicate) > Attachments don't make it through the mailing list, > Uhm, sorry. I'm new here. I don't want to paste the SQL script in an email, because it contains line breaks and I don't want the formatting to change during email transport. Try

Re: [sqlite] Unnecessary line breaks in .dump output

2009-03-27 Thread Simon Davies
2009/3/27 Francois Botha : > > The example you used, works 100% for me.  I attach a sql script for which I > experience the problem. > Attachments don't make it through the mailing list, Rgds, Simon ___ sqlite-users mailing

Re: [sqlite] Unnecessary line breaks in .dump output

2009-03-27 Thread Francois Botha
> > > See if you get same problem using data above. > If not, then your data is relevant to the issue. > If yes, then your sqlite is not the same as mine. > > Rgds, > Simon The example you used, works 100% for me. I attach a sql script for which I experience the problem. Extract it and do:

[sqlite] Unnecessary line breaks in .dump output

2009-03-27 Thread Francois Botha
Hi, I noticed that there is unnecessary line breaks in the .dump output, specifically \n characters, (not full \r\n 's). To illustrate this Put this in a loop (say about a 100) times: sqlite3.exe MyDB.s3db .dump > MyDB.sql del MyDB.s3db sqlite3.exe -init MyDB.sql MyDB.s3db .quit With each