thanks Michael, my typing 2 forward slashes wasn't intentional, I realized after I posted what I'd done, but it's good to know I can a forward slash instead, so as long it it just goes to the C drive and no further, it should be OK for all users?
Mark ----- Original Message ----- From: "Black, Michael (IS)" <michael.bla...@ngc.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>; "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, June 02, 2010 1:04 PM Subject: Re: [sqlite] output problem > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users