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)" <[email protected]> To: "General Discussion of SQLite Database" <[email protected]>; "General Discussion of SQLite Database" <[email protected]> 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: [email protected] 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" <[email protected]> > To: "General Discussion of SQLite Database" <[email protected]> > Sent: Wednesday, June 02, 2010 11:55 AM > Subject: Re: [sqlite] output problem > > > On 1 June 2010 12:52, Mark <[email protected]> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

