Re: [sqlite] Intermittent "malformed database schema"

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Simon, thank you for the quick reply! On Dienstag, 15. Januar 2013 12:14:20, Simon Slavin wrote: > > On 15 Jan 2013, at 9:50am, Marcus Ilgner <mar...@doo.net> wrote: > >> every now and then - very hard to reproduce - I

[sqlite] Intermittent "malformed database schema"

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, every now and then - very hard to reproduce - I get the SQLite error "malformed database schema" (error code 1). This happens when running lots of schema-changing statements after another and seems to occur only on systems with a very fast

Re: [sqlite] Simple SQLite-based spreadsheet?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Freitag, 7. Dezember 2012 16:38:05, David Bicking wrote: >> From: Gilles Ganault > >> On Fri, 7 Dec 2012 13:37:45 +, Simon Slavin > wrote: >> Use the free SQLite shell tool downloadable from the

Re: [sqlite] select ... where problem

On Donnerstag, 20. September 2012 15:16:29, 叶艳红 wrote: > insert into history (mdwkup,macdup,mdate,mdwkmd) SELECT > (select count(*) FROM fxj where mdwkup=1), > (select CURDATE()), > (select round(avg(mdwkmd),2) from fxj) where datetime('now', > 'localtime')>15:00 > > The sql command could not run

Re: [sqlite] Strategies for checking the version of a database?

r_version pragma (don't use schema_version) to store this information. See http://www.sqlite.org/pragma.html#pragma_schema_version All the best Marcus Ilgner ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Count(*) help

bly looking for something like SELECT COUNT(*) FROM Members WHERE Year2012='Paid' or maybe even SELECT Year2012, COUNT(*) FROM Members GROUP BY Year2012 All the best Marcus Ilgner ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Windows 8: debugging "table is locked" errors

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 13.09.2012 17:50, Joe Mistachkin wrote: > Marcus Ilgner wrote: >> >> I'm one of the authors of the SQLite-WinRT component for Windows >> 8. > > Cool, the one on CodePlex? > Oh, sorry, I forgot to include the link [1

[sqlite] Windows 8: debugging "table is locked" errors

of work to support seamless multi-threading and since the one application is the only process working on the database, I suspect that the problem may lie elsewhere. All the best Marcus Ilgner -- doo Windows Team doo GmbH | Argelander Strasse 1 | D-53115 Bonn https://doo.net | @ma_il <ht