Steve Frierdich wrote:
In the Sqlite version 2.8.15 I used the sqlite_get_table function that works with a return value of SQLITE_OK.
In the Sqlite version 3.0.7 I used the sqlite3_get_table function that fails with a return value of 26, which is:
"File opened that is not a database file ".
Both version used the same database. Why does one function work in the one version and the same type of function function fail in another? Do I now have to go through and recreate all the databases used in sqlite version 2.x.xx in a new sqlite explorer?
Thanks Steve
SQLite2 and SQLite3 use a different file format, so SQLite3 cannot read SQLite2 files and SQLite2 cannot read SQLite3 files.
Use the SQLite2 command line to dump your table: sqlite2 yourdbfile .dump >dump.sql
then import your dump.sql in a new sqlite3db sqlite3 yournewdb .read "dump.sql"
