On Mon, 2007-01-29 at 19:26 -0300, Brodie Thiesfield wrote:
> Does sqlite support numeric literals in hexadecimal?
> e.g.INSERT INTO table(mask) VALUES (0x);
I don't think so.
> Additionally, is there a constant like MAX_INTEGER defined which I can
> use as the maximum value that an INTEGER f
--- 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, e3_
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 thi
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:
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
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
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 [mailto:[E
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
-
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 me
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 Kish
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 exactl
> 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 sta
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
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 tho
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 2
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 nu
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
an
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 implementatio
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:
>
19 matches
Mail list logo