Re: [sqlite] SQLite 3 file format changed?

2006-02-20 Thread Firman Wandayandi
On 2/20/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Version 3.3.0, 4th bullet: "More efficient coding of boolean > values resulting in a smaller database file" > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > Oh that's it! But seems doesn't like file format log changed :-) On 2/20/06,

Re: [sqlite] Older sources

2006-02-20 Thread Jens Miltner
Am 20.02.2006 um 10:08 schrieb Manfred Bergmann: Am 20.02.2006 um 19:12 schrieb Jose Da Silva: On February 19, 2006 06:45 pm, Manfred Bergmann wrote: Hi there. I would need the sources of an older version (3.1.2) of SQLite. Are they still available for download? If nobody has it, go to

Re: [sqlite] SQLite 3 file format changed?

2006-02-20 Thread drh
"Firman Wandayandi" <[EMAIL PROTECTED]> wrote: > Hi, > > I use PHP PDO_SQLITE extension with SQLite 3.2.8 library, I try to > open a database version 3 which I use SQLiteSpy 1.5.2 with SQLite > 3.3.4 library, then PDO said error message like "unsupported file > format". I tried to use sqlite3

Re: [sqlite] Older sources

2006-02-20 Thread drh
Manfred Bergmann <[EMAIL PROTECTED]> wrote: > Hi there. > > I would need the sources of an older version (3.1.2) of SQLite. > Are they still available for download? > All SQLite source code going back to version 1.0 and even before that is available via CVS. Instructions at

Re: [sqlite] Disable index?

2006-02-20 Thread drh
Jim Dodgen <[EMAIL PROTECTED]> wrote: > one simple trick I first started using with oracle and also use with > sqlite is to do the following on the where clause > for numerics > where filda = fldb+0 > > for strings > > where flda = fldb||"" > > this would cause a index on fldb to be ignored

[sqlite] More sqlite databases in temp folder. Was: help

2006-02-20 Thread drh
"SnapinPop" <[EMAIL PROTECTED]> wrote: > dont want this on my pc. found sqlite files in my temp solder that wont be > deleted as in use by other program and dont know which one. shred it but > comes back as a new one. never was there. b4. how to delete sqlite. SQLite is not an application. It

[sqlite] unsubsribe

2006-02-20 Thread Oliver Manthey
unsubsribe

Re: [sqlite] Best way to get rowID of SELECT DISTINCT

2006-02-20 Thread Denis Sbragion
Hello Marco, On Mon, February 20, 2006 09:56, Marco Bambini wrote: > I have also tried this: > CREATE VIEW v1 AS SELECT DISTINCT Artist FROM trax; > SELECT rowid FROM v1 may be: CREATE VIEW v1 AS SELECT Artist, min(rowid) as firstid FROM trax GROUP BY Artist; This view will provide you the

Re: [sqlite] Older sources

2006-02-20 Thread Manfred Bergmann
Am 20.02.2006 um 19:12 schrieb Jose Da Silva: On February 19, 2006 06:45 pm, Manfred Bergmann wrote: Hi there. I would need the sources of an older version (3.1.2) of SQLite. Are they still available for download? If nobody has it, go to google and search for these 3 words: sqlite 3.1.2 rpm

[sqlite] Best way to get rowID of SELECT DISTINCT

2006-02-20 Thread Marco Bambini
I need to get rowid of DISTINCT records, but so far all my test fails. I have also tried this: CREATE VIEW v1 AS SELECT DISTINCT Artist FROM trax; SELECT rowid FROM v1 but the rowid column is empty... Any help is really appreciated... --- Marco Bambini http://www.sqlabs.net

Re: [sqlite] Older sources

2006-02-20 Thread Jose Da Silva
On February 19, 2006 06:45 pm, Manfred Bergmann wrote: > Hi there. > I would need the sources of an older version (3.1.2) of SQLite. > Are they still available for download? If nobody has it, go to google and search for these 3 words: sqlite 3.1.2 rpm or sqlite 3.1.2 tar.gz The response is many

Re: [sqlite] using sqlite3 in php

2006-02-20 Thread Firman Wandayandi
On 2/20/06, Lloyd Thomas <[EMAIL PROTECTED]> wrote: > sqlite3 is available in 5.1 using the pdo extensions. > have a look at www.php.net/pdo > I had the same problem with an app I wrote in delphi to insert records and > used php front end to select records > The lastest SQLite library on PDO is