[sqlite] output from sqlite3 .dump not going where I expected

2016-05-08 Thread Kees Nuyt
On Sun, 08 May 2016 15:42:29 +0100, Jeremy Nicoll wrote: > This doesn't (or does it?) explain why .output > "C:\a\valid\path\file.txt" doesn't work, though. > Why would sqlite3 decide that this meant an unpathed file named > "avalidpathfile.txt" ? The backslash '\' is an escape

[sqlite] output from sqlite3 .dump not going where I expected

2016-05-08 Thread Simon Slavin
On 8 May 2016, at 3:42pm, Jeremy Nicoll wrote: > Is there a way to get sqlite3 to > say what version > of the DLL it's using Take a look at the functions on this page which start with "sqlite_". Note that some of them were introduced recently

[sqlite] output from sqlite3 .dump not going where I expected

2016-05-08 Thread Jeremy Nicoll
On Sun, 8 May 2016, at 14:33, R Smith wrote: > You are correct that the Windows virtualization is the cause of this, as > you already figured out. The only reason any output would be virtualized > is that Windows regards the folder used (or default if none is > specified) as one of the

[sqlite] output from sqlite3 .dump not going where I expected

2016-05-08 Thread R Smith
On 2016/05/08 10:57 AM, Jeremy Nicoll wrote: > I'm using Windows 8.1, 64bit, and yesterday installed the V3.12.02 > 64-bit DLL along with > the 32-bit SQLite tools. > > I was investigating the contents of a logs file created by my antivirus > & firewall package, > which keeps that file in > >

[sqlite] output from sqlite3 .dump not going where I expected

2016-05-08 Thread Keith Medcalf
t > Subject: Re: [sqlite] output from sqlite3 .dump not going where I expected > > On 5/8/16, Jeremy Nicoll wrote: > > I'm using Windows 8.1, 64bit, and yesterday installed the V3.12.02 > > > > I then tried eg > > > > .output myfile.txt > > .dump > > &g

[sqlite] output from sqlite3 .dump not going where I expected

2016-05-08 Thread Jeremy Nicoll
I'm using Windows 8.1, 64bit, and yesterday installed the V3.12.02 64-bit DLL along with the 32-bit SQLite tools. I was investigating the contents of a logs file created by my antivirus & firewall package, which keeps that file in C:\Program Files\Emsisoft Internet Security\Logs\logs.db3

[sqlite] output from sqlite3 .dump not going where I expected

2016-05-08 Thread Richard Hipp
On 5/8/16, Jeremy Nicoll wrote: > I'm using Windows 8.1, 64bit, and yesterday installed the V3.12.02 > > I then tried eg > > .output myfile.txt > .dump > > and was perplexed that no "myfile.txt" file was created anywhere obvious When I try this on my Win10 box, I see that the "myfile.txt" file