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

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:

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

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