[sqlite] SQLite 3 release

2004-09-17 Thread Jakub Adamek
Hello, Dr. Hipp, please, what is the time estimate for releasing the version 3? I believe that it's not only me looking forward to it! It is too lovely, the version 3, how long should I live with version 2? :-)) Jakub

Re: [sqlite] SQLITE_ERROR instead of SQLITE_FULL

2004-09-17 Thread D. Richard Hipp
George Ionescu wrote: > > So, my question is this: if sqlite cannot insert data into the database > because it doesn't have enough free space, shouldn't it return SQLITE_FULL > insted of SQLITE_ERROR ? > Did you write a ticket? -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] SQLite 3 release

2004-09-17 Thread D. Richard Hipp
Jakub Adamek wrote: Hello, Dr. Hipp, please, what is the time estimate for releasing the version 3? I believe that it's not only me looking forward to it! It is too lovely, the version 3, how long should I live with version 2? :-)) I had hoped to do a release this week. But there are some error

[sqlite] Thank you

2004-09-17 Thread Philip Hofstetter
Hello, I'm just passing by to say a big fat "thank you" to the SQLite developers. We actually managed to compile SQLite for an Intermec ck1 barcode scanner/mobile computer (running ucLinux). It required some hacking around as we were not able to get the configure script to run properly, but in t

[sqlite] sqlite 3.0 without 64 bit ints

2004-09-17 Thread Dennis Cote
Hi, Has anyone tried or succeeded in building SQLite 3.0 with a compiler that doesn't support 64 bit integers? Alternatively, does anyone know what won't work with a version built with 32 bit ints only? The databases we use are not so big that they need 64 bit keys etc. We are satisfied with the

[sqlite] What does the first expr do in a CASE statement ?

2004-09-17 Thread Randall Fox
What does the first expr do in a CASE expression ? I understand the rest of the syntax, but I don't get what the very first expr (after the keyword "case") does.. And I couldn't find the answer in the documentation or wiki.. Thanks Randall Fox

Re: [sqlite] What does the first expr do in a CASE statement ?

2004-09-17 Thread John LeSueur
Randall Fox wrote: What does the first expr do in a CASE expression ? I understand the rest of the syntax, but I don't get what the very first expr (after the keyword "case") does.. And I couldn't find the answer in the documentation or wiki.. Thanks Randall Fox There's a few ways you can use c

Re: [sqlite] What does the first expr do in a CASE statement ?

2004-09-17 Thread Randall Fox
On Fri, 17 Sep 2004 19:49:34 -0600, you wrote: >Randall Fox wrote: > >>What does the first expr do in a CASE expression ? >> >>I understand the rest of the syntax, but I don't get what the very >>first expr (after the keyword "case") does.. And I couldn't find the >>answer in the documentation or