Inside code you can use forward slash for path seperators (dang Microsoft for ever introducing this backslash stuff). so this works on ALL windows operating systems that I know of .output c:/done.txt Note though that if your user doesn't have admin priveledges they may not be able to write to the root of C: drive. Michael D. Black Senior Scientist Northrop Grumman Mission Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of CDN Mark Sent: Wed 6/2/2010 6:48 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] output problem thanks Simon, that worked, why is this? and if I wanted to send this to someone else and it had the // would it NOT work for them? Mark ----- Original Message ----- From: "Simon Davies" <simon.james.dav...@googlemail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, June 02, 2010 11:55 AM Subject: Re: [sqlite] output problem On 1 June 2010 12:52, Mark <m.co...@virgin.net> wrote: > Hi, > > trying to use .output to write a small text file, and send it to the C > drive. It looks like this: > > .read UnPop.sql > .output C:\done.txt > .dump dbinfo > .quit > > works fine if I send it to the E drive, but as soon as I try anywhere on > the C, whether to the drive itself, or a folder on C, it just doesn't work > at all, > nothing is created. I do need it it to go to at least the C drive, and > preferably a folder on C looks like Windoze - double up your '\' chars, i.e. .output C:\\done.txt > > mtia, > Mark Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
