Re: [sqlite] OT!!!!! Understanding the WITH clause

2019-06-19 Thread Michael Falconer
SELECT peace FROM disaster WHERE disaster.cause = 'Windows'; Returns: *nix On Thu, 20 Jun 2019 at 14:26, Sam Carleton wrote: > James, > > That is a really, really interesting quote. it really got me thinking > about peace and the definition of it. It got me thinking so much I wanted > to kno

Re: [sqlite] OT!!!!! Understanding the WITH clause

2019-06-19 Thread Sam Carleton
James, That is a really, really interesting quote. it really got me thinking about peace and the definition of it. It got me thinking so much I wanted to know the context of the sentence, so I went looking for it in Letter from the Birmingham Jail, this is my source link ( http://web.cn.edu/kwhe

Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

2019-06-19 Thread Kevin Benson
On Wed, Jun 19, 2019 at 12:12 PM Carsten Müncheberg < carsten.muencheb...@native-instruments.de> wrote: > Am 19.06.2019 um 16:47 schrieb Igor Tandetnik: > > On 6/19/2019 10:39 AM, Carsten Müncheberg wrote: > >> Is there really something like a table lock? > > > > Yes there is: https://sqlite.org/s

Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

2019-06-19 Thread Carsten Müncheberg
Am 19.06.2019 um 16:47 schrieb Igor Tandetnik: On 6/19/2019 10:39 AM, Carsten Müncheberg wrote: Is there really something like a table lock? Yes there is: https://sqlite.org/sharedcache.html Thanks, I wasn't aware of that. -- Carsten Müncheberg Software Developer Native Instruments GmbH ww

Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

2019-06-19 Thread Simon Slavin
On 19 Jun 2019, at 3:39pm, Carsten Müncheberg wrote: > /* SQLITE_BUSY*/ "database is locked", > /* SQLITE_LOCKED */ "database table is locked", With two different connections, either by the same program or different programs/computers, you will see SQLITE_BUSY . SQLITE_BUSY is

Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

2019-06-19 Thread Igor Tandetnik
On 6/19/2019 10:39 AM, Carsten Müncheberg wrote: Is there really something like a table lock? Yes there is: https://sqlite.org/sharedcache.html -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.

[sqlite] SQLITE_LOCKED means "database table is locked"?

2019-06-19 Thread Carsten Müncheberg
I'm puzzled by the error strings for SQLITE_BUSY and SQLITE_LOCKED. The documentation for both is very clear and precise, but these too strings which are returned by sqlite3_errmsg() are misleading in my opinion, especially "database table is locked". Is there really something like a table lock