On my mac, sqlite3 -version shows 3.1.3 which is not forward compatible
with the default format for 3.3.6 unless you use the PRAGMA:
PRAGMA legacy_file_format=TRUE;
Before you create the database.
To use the old version as the default, you can compile the lib yourself
with:
-DSQLITE_DEFAULT_FILE_FORMAT=1
Alternatively, you could get the source and build a compatible sqlite
client.
Pat
-Original Message-
From: Hartwig Wiesmann [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 09, 2006 3:25 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] sqlite3 on MacOSX
Hello!
I have created a database (let's name it "Test.db") on the Mac by
using the sqlite lib (sqlite version 3.3.6) in my program. Everything
works fine.
I also wanted to check the database contents using the sqlite command
line program. Calling "sqlite3 Test.db" from the terminal and
afterwards sending the command ".databases" leads to an error message
"unsupported file format".
What am I doing wrong?
Hartwig
