Re: [sqlite] a couple of pre-initial questions

2016-07-06 Thread Niall O'Reilly
On 6 Jul 2016, at 17:15, John R. Sowden wrote: A few questions. Q1: I am running xubuntu. When I search for sqlite3, lots of things show up. This database engine seems to be very popular, so I assume it is used my many programs on my computer, like Thunderbird. Why, then when I enter

Re: [sqlite] a couple of pre-initial questions

2016-07-06 Thread R Smith
On 2016/07/06 6:15 PM, John R. Sowden wrote: Good Morning: I am a pre-newbie. A few questions. Q1: I am running xubuntu. When I search for sqlite3, lots of things show up. This database engine seems to be very popular, so I assume it is used my many programs on my computer, like

Re: [sqlite] a couple of pre-initial questions

2016-07-06 Thread Richard Hipp
On 7/6/16, John R. Sowden wrote: > Q1: I am running xubuntu. When I > search for sqlite3, lots of things show up. This database engine seems > to be very popular, so I assume it is used my many programs on my > computer, like Thunderbird. Why, then when I enter

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Eduardo Morras
On Wed, 6 Jul 2016 18:10:34 +0200 Chris Brody wrote: > > > > Just for my information, what is the purpose of this temporary > > file? I see > >> that -journal file is always stored to disk. > >> > > > > It's a statement journal: > > > >

Re: [sqlite] a couple of pre-initial questions

2016-07-06 Thread Adam Devita
Good day, Q2: Documentation, see http://www.sqlite.org/docs.html Q1: Often sqlite support is compiled into the code, so there is not "run sqlite". It is often used as a dll or shared object, which aren't executable from the command prompt. The command line shell (and source code to compile it)

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Dan Kennedy
On 07/06/2016 11:10 PM, Chris Brody wrote: Just for my information, what is the purpose of this temporary file? I see that -journal file is always stored to disk. It's a statement journal: https://www.sqlite.org/tempfiles.html#stmtjrnl Recent changes mean that the first 64KiB of a

[sqlite] a couple of pre-initial questions

2016-07-06 Thread John R. Sowden
Good Morning: I am a pre-newbie. A few questions. Q1: I am running xubuntu. When I search for sqlite3, lots of things show up. This database engine seems to be very popular, so I assume it is used my many programs on my computer, like Thunderbird. Why, then when I enter sqlite3 at

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Chris Brody
> > Just for my information, what is the purpose of this temporary file? I see >> that -journal file is always stored to disk. >> > > It's a statement journal: > > https://www.sqlite.org/tempfiles.html#stmtjrnl > > Recent changes mean that the first 64KiB of a statement journal are always >

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Dan Kennedy
On 07/06/2016 10:52 PM, Jeff Archer wrote: On Wed, Jul 6, 2016 at 10:46 AM, Dan Kennedy wrote: On 07/06/2016 09:09 PM, Jeff Archer wrote: Hi All, I am a long time SQLite user but have generally used it from C++ in the past. In this project however, I am attempting to

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Jeff Archer
On Wed, Jul 6, 2016 at 10:46 AM, Dan Kennedy wrote: > On 07/06/2016 09:09 PM, Jeff Archer wrote: > >> Hi All, >> I am a long time SQLite user but have generally used it from C++ in the >> past. In this project however, I am attempting to make a JDBC wrapper and >> use

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Dan Kennedy
On 07/06/2016 09:09 PM, Jeff Archer wrote: Hi All, I am a long time SQLite user but have generally used it from C++ in the past. In this project however, I am attempting to make a JDBC wrapper and use from Android a newer version of SQLite (3.12.2) than that provided by Android 4.2.2 (3.7.11).

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Quan Yong Zhai
It seemed that SQLite can’t create a temporary file,: PRAGMA TEMP_STORE=MEMORY From: Quan Yong Zhai Sent: 2016年7月6日 22:35 To: Jeff Archer; sqlite-users@mailinglists.sqlite.org Subject: RE: [sqlite]

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Quan Yong Zhai
PRAGMA JOURNAL_MODE=MEMORY Sent from Mail for Windows 10 From: Jeff Archer Sent: 2016年7月6日 22:10 To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Problem with

[sqlite] Problem with savepoints

2016-07-06 Thread Jeff Archer
Hi All, I am a long time SQLite user but have generally used it from C++ in the past. In this project however, I am attempting to make a JDBC wrapper and use from Android a newer version of SQLite (3.12.2) than that provided by Android 4.2.2 (3.7.11). Basically, what I have is SQLite compiled

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

2016-07-06 Thread Nick Wellnhofer
On 05/07/2016 18:12, Richard Hipp wrote: Please try https://www.sqlite.org/src/info/2683b375ad129117 and verify that the changes on trunk are working. Thanks. Still doesn't work for me. The structure of the #ifdefs in `Parse` is: #ifdef YYERRORSYMBOL ... #elif