[sqlite] Using sqlite3_backup* while the destination connection has "busy" read-only statements.

2014-11-12 Thread Shaun Seckman (Firaxis)
Greetings all, I'm running into a situation in where our application is crashing during a call to sqlite_backup_finish inside of btreeParseCellPtr because some of the structure is corrupted. Both the source and destination database are using the same page sizes and I'm running everything from

Re: [sqlite] cnt(x) what do the brackets signify

2014-11-12 Thread Paul Sanderson
Thanks Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC processing made

Re: [sqlite] Triggers and CTE's

2014-11-12 Thread James K. Lowden
On Tue, 11 Nov 2014 17:15:53 -0600 Ben Newberg wrote: > CREATE TRIGGER t_populate_zweeks > AFTER UPDATE ON zSPs WHEN new.Procedure = 6 AND new.Flag = 1 > BEGIN > DELETE FROM zWeeks; > WITH RECURSIVE Weeks(wk) as (select 1 union all select wk + 1 from > Weeks limit 10) >

Re: [sqlite] cnt(x) what do the brackets signify

2014-11-12 Thread Igor Tandetnik
On 11/12/2014 12:52 PM, Paul Sanderson wrote: I have googled but can't see what cnt(x) actually signifies - cnt is not a function The same thing it signifies in "CREATE TABLE cnt(x);" "cnt" is an "ephemeral" table with a single column named "x". -- Igor Tandetnik

Re: [sqlite] cnt(x) what do the brackets signify

2014-11-12 Thread Stephan Beal
On Wed, Nov 12, 2014 at 6:52 PM, Paul Sanderson < sandersonforens...@gmail.com> wrote: > I have googled but can't see what cnt(x) actually signifies - cnt is > not a function - could someone point me to a resource so I can > understand this construct > The diagram at the top of this page

[sqlite] cnt(x) what do the brackets signify

2014-11-12 Thread Paul Sanderson
I am looking at recursive cte and saw this example I have googled but can't see what cnt(x) actually signifies - cnt is not a function - could someone point me to a resource so I can understand this construct Thanks WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE

[sqlite] sliteonline or sqlite in js

2014-11-12 Thread Kirill
Good day, Full line manager to work with sqlite directly from the browser on any platform: http://sqliteonline.com/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users