Re: [sqlite] sqlite3 on MacOSX
Thanks! Using the latest sqlite3 command tool helped! Hartwig
[sqlite] List-Unsubscribe
On 7/9/06, Pat Wibbeler <[EMAIL PROTECTED]> wrote: 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
RE: [sqlite] sqlite3 on MacOSX
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
Re: [sqlite] sqlite3 on MacOSX
On 7/9/06, Hartwig Wiesmann <[EMAIL PROTECTED]> wrote: What am I doing wrong? Are you using the version of the sqlite command-line utility that comes with Tiger? If so, it isn't going to be compatible with the database you created, unless you are careful to create an old-legacy database. Try the sqlite that you get when you build package and I bet you'll have better luck.
Re: [sqlite] Re: attached databases
Thanks Igor! --- Igor Tandetnik <[EMAIL PROTECTED]> wrote: > carl clemens > > wrote: > > Is there away to get sqlite3 *db pointer to an > > attached database? I'm looking to load user > defined > > functions into them from a shared library. > > User-defined functions are created on a connection, > not on a particular > database. Once you install your user-defined > functions, you can use them > in a query across any or all databases associated > with this connection. > > Igor Tandetnik > > __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com