RE: [sqlite] Limit statement size?

--- RB Smissaert <[EMAIL PROTECTED]> wrote: > Thanks, that is how I understood it to be. > I must be overlooking something simple here. Check your SELECT sub-statement within the REPLACE statement to see what rows it returns. .header on .mode tabs create table t1(id primary key, e2_a, e2_b,

Re: [sqlite] SQLite documentation

On 1/29/07, Clark Christensen <[EMAIL PROTECTED]> wrote: Puneet, How about "make doc"? If you have TCL, that seems to generate the HTML output in ./doc. If you don't, I'd be happy to send it to you. Thanks Clark. I had, and it did. Me happy. I am wondering though, how would I have known

Re: [sqlite] SQLite documentation

Puneet, How about "make doc"? If you have TCL, that seems to generate the HTML output in ./doc. If you don't, I'd be happy to send it to you. -Clark - Original Message From: P Kishor <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, January 29, 2007 10:13:05 AM Subject:

RE: [sqlite] Limit statement size?

Thanks, that is how I understood it to be. I must be overlooking something simple here. RBS -Original Message- From: Gerry Snyder [mailto:[EMAIL PROTECTED] Sent: 29 January 2007 23:52 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Limit statement size? RB Smissaert wrote: > Had a go

Re: [sqlite] Limit statement size?

RB Smissaert wrote: Had a go at this, but sofar I haven't been able yet to get it to work. I get no error, but A3Test115_J remains just at it is. I couldn't find much information about INSERT OR REPLACE in the SQLite documentation. What exactly should it do? It will try to do an INSERT. If the

RE: [sqlite] Limit statement size?

Had a go at this, but sofar I haven't been able yet to get it to work. I get no error, but A3Test115_J remains just at it is. I couldn't find much information about INSERT OR REPLACE in the SQLite documentation. What exactly should it do? RBS -Original Message- From: Joe Wilson

[sqlite] Hexadecimal literals or MAX_INTEGER definition?

Does sqlite support numeric literals in hexadecimal? e.g.INSERT INTO table(mask) VALUES (0x); Additionally, is there a constant like MAX_INTEGER defined which I can use as the maximum value that an INTEGER field supports (assuming that types actually exist)? Regards, Brodie

[sqlite] Memory database to file

Hi, I've got an application that creates a database with a large number of records (millions), and the indexation of the tables is taking a long time. Once the database is initially created, it is never modified. No records are added or deleted. So, in the case where a user has sufficient

[sqlite] SQLite documentation

Isn't there a way to generate html documentation for SQLite from the source files? I have a www folder with a bunch of Tcl files (which seem like I need to run them through Tcl to get html out), but no html. I am missing something obvious, so please point me in the right direction. -- Puneet

Re: [sqlite] Obtaining randomness on win32

Marco Bambini <[EMAIL PROTECTED]> wrote: > I really think that this article > http://eternallyconfuzzled.com/arts/jsw_art_rand.aspx > worths a read. > > It talks about the general rand function and the problem of > distribution... SQLite has always used an RC4-based PRNG, not rand(), for

AW: [sqlite] Obtaining randomness on win32

> randomness as you need. But I do not know how to do this on > win32 and wince. The current implementation seeds the random As Michael already suggested, you should use the CryptoAPI (CryptAquireContext, CryptGenRandom). This API is supported by all 32 bit desktop versions and by Windows CE

Re: [sqlite] Obtaining randomness on win32

John Stanton <[EMAIL PROTECTED]> wrote: > Have you considered an option where the user can supply the seed so that > an application can implement a complete sequence from the pseudo random > number generator? > When testing (-DSQLITE_TEST=1) the seed is always 256 bytes of 0x00. That way the

Re: [sqlite] Obtaining randomness on win32

On 1/29/07, Michael Ruck <[EMAIL PROTECTED]> wrote: On Windows itself you could use the CryptAcquireContext, CryptGenRandom and CryptReleaseContext. I think that doesn't work on WinCE though. It will work on Windows CE since version 2.10, as long as the OS was built with support for it (for

Re: [sqlite] Obtaining randomness on win32

I really think that this article http://eternallyconfuzzled.com/arts/jsw_art_rand.aspx worths a read. It talks about the general rand function and the problem of distribution... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jan

Re: [sqlite] Obtaining randomness on win32

Have you considered an option where the user can supply the seed so that an application can implement a complete sequence from the pseudo random number generator? This might help with Win32. http://msdn2.microsoft.com/en-us/library/aa387694.aspx [EMAIL PROTECTED] wrote: The pseudo-random

AW: [sqlite] Obtaining randomness on win32

I'm not sure if this helps, but QueryPerformanceCounter could be a source of semirandom 64-bit integers. It returns the processors running time in nanoseconds. I'm not aware of anything, which returns really random values. On Windows itself you could use the CryptAcquireContext, CryptGenRandom

[sqlite] Obtaining randomness on win32

The pseudo-random number generator (PRNG) in SQLite is becoming more important so it seem good to make sure it is well seeded. On Unix this is easy - just open /dev/urandom and read out as much randomness as you need. But I do not know how to do this on win32 and wince. The current

Re: [sqlite] enforcing Foreign Keys

To unsubscribe, send email to [EMAIL PROTECTED] - Original Message From: Mag Gam <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Saturday, January 27, 2007 9:13:11 AM Subject: Re: [sqlite] enforcing Foreign Keys So...anyone? On 1/25/07, Martin Jenkins <[EMAIL PROTECTED]> wrote: