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,
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
"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
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
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
"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
unsubsribe
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
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
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
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
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
12 matches
Mail list logo