Re: [sqlite] Calculating a checksum within SQLite, without using an extension...

Hello again, I found a problem with the example I sent earlier. I'm fairly new to dealing with blob data and didn't realize that substr([some_blob], 1, 1) didn't return a byte value, at least not one that can be cast as its' decimal integer value. I have fixed the problem by using a lookup

Re: [sqlite] Corrupted database file.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/05/2011 11:05 AM, Greg Morehead wrote: > Any insights on how this could occur would be greatly appreciated. http://www.sqlite.org/lockingv3.html#how_to_corrupt Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment:

Re: [sqlite] R: Crypto lib for Sqlite - suggest required

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/08/2011 04:36 AM, Marco Turco wrote: > Essentially I would avoid that my competitors can look inside the Db > structure and import data. On any machine where the database is used the key will have to exist in plain form no matter how convoluted

[sqlite] Calculating a checksum within SQLite, without using an extension...

Hello, I was bored so I wrote a quick recursion test that calculates a Fletcher32 checksum and it works! At least I think it does, I can't find any test vectors for Fletcher32. I realize it would be better to implement this as an extension library, but I was using it as an exercise to get a

Re: [sqlite] SQLite version with a query

OK, I'm blind! Just searched in the pragma when I think about it! Thanks On Sat, Jan 8, 2011 at 5:15 PM, Richard Hipp wrote: > On Sat, Jan 8, 2011 at 5:08 PM, Nicolas Buduroi > wrote: > > > Hi, first post here. I'm wondering if there a way to get the

Re: [sqlite] SQLite version with a query

On Sat, Jan 8, 2011 at 5:08 PM, Nicolas Buduroi wrote: > Hi, first post here. I'm wondering if there a way to get the SQLite version > with a query. I didn't found anything related to that in the documentation > (or I'm blind) but maybe there's an undocumented way. >

[sqlite] SQLite version with a query

Hi, first post here. I'm wondering if there a way to get the SQLite version with a query. I didn't found anything related to that in the documentation (or I'm blind) but maybe there's an undocumented way. ___ sqlite-users mailing list

Re: [sqlite] Advice on breaking trigger recursion?

On Sat, Jan 08, 2011 at 12:07:08PM +0700, Dan Kennedy wrote: > On 01/08/2011 08:12 AM, Nicolas Williams wrote: > > I need to use recursive triggers. In some cases I want to "normalize" > > values of some columns of NEW being INSERTed or UPDATEd, but there's no > > UPDATE syntax for changing NEW,

Re: [sqlite] Result set column names

Jay A. Kreibich wrote, On 08/01/11 14:07: > On Sat, Jan 08, 2011 at 09:12:36AM +, Simon Slavin scratched on the wall: >> >> On 8 Jan 2011, at 9:09am, Peter wrote: >> >>> So the 'column name' may be some internal representation/magic number >>> and bear no direct relationship to the name in the

Re: [sqlite] Embarassed Newbie

Hello Michael, Yeah, sqlite3.exe runs everywhere. This problem is more basic. Sqlite3.exe is in some other path and not in the command line search path. Where did you unzip the files? Either do the test from the folder you unzipped the files to or use full path C:> C:\Unzipped\Sqlite3.exe

Re: [sqlite] Crypto lib for Sqlite - suggest required

Hi Marco, > I am looking for a Crypto lib to encrypt the Sqlite Db in full but I would > like something less expensive that provided from the Sqlite author. > I have found some libs on www.sqlite-cript.com and www.sqlite-encrypt.com. > I would like your opinion about these libs and any other you

Re: [sqlite] Result set column names

On Sat, Jan 08, 2011 at 09:12:36AM +, Simon Slavin scratched on the wall: > > On 8 Jan 2011, at 9:09am, Peter wrote: > > > So the 'column name' may be some internal representation/magic number > > and bear no direct relationship to the name in the projector as supplied > > in the SELECT? >

Re: [sqlite] Embarassed Newbie

Richard Hipp wrote, On 08/01/11 13:10: > On Sat, Jan 8, 2011 at 8:06 AM, Peter wrote: >> On 08/01/11 11:43, james630...@aol.com wrote: >>> sqlite3 test.db >> >> I assume by 'binaries' you mean sqlite-shell-win32... and >> sqlite-dll-win32...? You need both to run