Hi there, I run Python 2.5 on a Mac OS X system with SQLite 3.2.8 installed via fink. Today I stumbled over the problem, that the sqlite3 module and sqlite3 from fink do not seem to work well together. I brought it down to this:
>>> from sqlite3 import Connection >>> c = Connection("foo.bar") # does not yet exist >>> c.execute("CREATE TABLE foo (id integer)") >>> c.execute("INSERT INTO foo VALUES (1)") >>> c.execute("SELECT * FROM foo") >>> c.execute("SELECT * FROM foo").fetchmany() [(1,)] >>> c.execute("INSERT INTO foo VALUES (2)") >>> c.execute("SELECT * FROM foo").fetchmany(2) [(1,), (2,)] Then in sqilte: $ sqlite3 foo.bar SQLite version 3.2.8 Enter ".help" for instructions sqlite> select * from foo; SQL error: unsupported file format If I create the database file with sqlite and open it from within python, I cannot run any queries on that database, but no error is thrown - it just passes silently. Any ideas? Regards, -Justin -- http://mail.python.org/mailman/listinfo/python-list