Re: [sqlite] sqlite3 on MacOSX

2006-07-09 Thread Hartwig Wiesmann
Thanks! Using the latest sqlite3 command tool helped! Hartwig

[sqlite] List-Unsubscribe

2006-07-09 Thread deepali rajale
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 ca

RE: [sqlite] sqlite3 on MacOSX

2006-07-09 Thread Pat Wibbeler
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_FIL

Re: [sqlite] sqlite3 on MacOSX

2006-07-09 Thread Will Leshner
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 t

[sqlite] sqlite3 on MacOSX

2006-07-09 Thread Hartwig Wiesmann
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 af

Re: [sqlite] Re: attached databases

2006-07-09 Thread carl clemens
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 connectio