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

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

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

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

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

.output means redirect from now henceforth until I change the output location. .once means to redirect output for only the next command. Windows is not buffering, it is just not updating the directory entry. When you use .output the file is not closed until you either (a) redirect elsewhere

[sqlite] ?????? database is locked when using SQLite3 and MPI togenerate different databases

Hi Simon, Thank you for your reply. I tired your solution, but I still got the same error message, even when I set PRAGMA busy_timeout = 1. -- -- ???: "Simon Slavin";; : 2016?5?8?(???) ??11:22 ???: "SQLite mailing list"; ??: Re: [sqlite]

[sqlite] Fw: new message

Hello! You have a new message, please read james.ander at tiscali.co.uk

[sqlite] determining is-leap-year in sqlite

On 8 May 2016 at 12:28, jungle Boogie wrote: > I'll set the TZ on the pi to match and see what happens. We're on to something! pi time: $ date Sun May 8 12:29:54 PDT 2016 x86 time: % date Sun May 8 12:30:04 PDT 2016 They match with cal.sql now! http://kopy.io/GbbDR So no problem with

[sqlite] determining is-leap-year in sqlite

On 8 May 2016 at 02:04, Stephan Beal wrote: > On Sun, May 8, 2016 at 10:53 AM, Stephan Beal > wrote: > >> The system clock is correct on your x64 machine, i assume? (Even if it's >> wrong, that doesn't explain the days being shifted left by 1.) >> > > One idea comes to mind: perhaps it doesn't

[sqlite] determining is-leap-year in sqlite

On Sun, May 8, 2016 at 10:53 AM, Stephan Beal wrote: > The system clock is correct on your x64 machine, i assume? (Even if it's > wrong, that doesn't explain the days being shifted left by 1.) > One idea comes to mind: perhaps it doesn't consistently deal with timezones everywhere, and you've

[sqlite] determining is-leap-year in sqlite

On Sun, May 8, 2016 at 2:14 AM, jungle Boogie wrote: > (8) is on Saturday, that's correct for 2016. > > (7) is on Friday and in fact, all the days are shifted once. > > Both of those are a bit difficult to follow here so this link has both: > http://kopy.io/NLViy > > What would cause the same

[sqlite] database is locked when using SQLite3 and MPI to generate different databases

Hi all, I would like to use SQLite3 and MPI to generate many databases, and different processes produce and process different databases. But when I ran the program in Linux, I got an error message from sqlite3_exec() that ?database is locked?. I know this message means I tried to do

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

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

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

[sqlite] database is locked when using SQLite3 and MPI to generate different databases

On 8 May 2016, at 3:14am, just_rookie <925345468 at qq.com> wrote: > But when I ran the program in Linux, I got an error message from > sqlite3_exec() that ?database is locked?. You have not set a timeout, so SQLite is quitting as soon as it is told that another thread/process has the