[sqlite] Encrypted or Corrupt File

2015-10-15 Thread Paul Sanderson
What chat application are they from. What was the last thing that you did before they stopped working Is there anything else on your computer that could be opening these fles Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786

[sqlite] Encrypted or Corrupt File

2015-10-15 Thread Simon Slavin
On 15 Oct 2015, at 7:37pm, Michael Horn wrote: > I am new to this and an amateur to say the least. I'm trying to recover > online some chat files. I'm using SQLite manager to read files and the > files I was just using yesterday are not opening. file error: either the > file is encrypted or

[sqlite] SQLite Release 3.9.0

2015-10-15 Thread Warren Young
On Oct 14, 2015, at 4:48 PM, Craig Maynard wrote: > > I'm not sure what semantic versioning says about this semver.org is not a very long page. Spec point 2 covers this: it does not allow empty X, Y, or Z components. > why not just drop the trailing .0 and call the release 3.9? That seems >

[sqlite] include "sqlite.h" in sqlite.h

2015-10-15 Thread bob
having #include "sqlite.h" inside of sqlite.h presumes the file is still called sqlite.h this makes deploying different versions very difficult.

[sqlite] Encrypted or Corrupt File

2015-10-15 Thread Michael Horn
I am new to this and an amateur to say the least. I'm trying to recover online some chat files. I'm using SQLite manager to read files and the files I was just using yesterday are not opening. file error: either the file is encrypted or corrupt component returned failure code 0x8052000b. Can

[sqlite] Version 3.9.0 source_id mismatch

2015-10-15 Thread Bruce Blackwell
I do not know if it is significant or not, but this is the first time I have ever seen this happen. sqlite3.dll from sqlite-dll-win32-x86-309.zip reports sqlite_source_id() as 2015-10-14 18:30:13 a43bb2b5cf9c7c19edbce37c883826eb0f7ed764 However, the amalgamation files have #define

[sqlite] sqlite window functions extension?

2015-10-15 Thread Igor Tandetnik
On 10/15/2015 9:36 AM, Don V Nielsen wrote: > limit ifnull( ( >select net_non_pieces from crrt_net_non net >where net.zip=zip and net.crrt=crrt I suspect this WHERE clause is equivalent to "where net.zip=net.zip and net.crrt=net.crrt" - that is,

[sqlite] sqlite window functions extension?

2015-10-15 Thread Don V Nielsen
I'm surprised that and extension for this type of functionality has not been been developed by someone with the c/c++. It's seems like a natural fit. I wish I had the kind of ability & smarts to do it. On Thu, Oct 15, 2015 at 9:04 AM, Igor Tandetnik wrote: > On 10/15/2015 9:36 AM, Don V

[sqlite] sqlite window functions extension?

2015-10-15 Thread Don V Nielsen
The correlated query was not accepted in the select statement. However, I modified your original UPDATE query, as follows, and it did execute, and passed the proper quantity of rows for the first zip/crrt combination, only. The rows were not updated. It counted correctly, but did not change the

[sqlite] include "sqlite.h" in sqlite.h

2015-10-15 Thread Richard Hipp
On 10/14/15, bob wrote: > having #include "sqlite.h" inside of sqlite.h presumes the file is > still called sqlite.h > this makes deploying different versions very difficult. That line can be omitted safely. -- D. Richard Hipp drh at sqlite.org

[sqlite] sqlite window functions extension?

2015-10-15 Thread R.Smith
On 2015-10-14 11:20 PM, Don V Nielsen wrote: > X has columns zip & crrt, just like crrt_net_non. These form a composite > key identifying groups within x. A value "53001.R501" would be an > example...53001 being the zip code and R501 being the carrier route. There > are 52 rows in X that have