On Thu, 2005-03-24 at 12:15 -0600, Jim Dodgen wrote: > just for testing I went into an existing 3.0.8 database with the 3.2.0 > sqlite3 > and added a column to a table. > then using the 3.0.8 sqlite3 went into the same database. > > [EMAIL PROTECTED] dbs]# sqlite3.0.8 ref.db > SQLite version 3.0.8 > Enter ".help" for instructions > sqlite> .schema > Error: unsupported file format
This is as documented. See for example http://www.sqlite.org/formatchng.html near the bottom. Version 3.2 is backwards but not forwards compatible. That's why the second number in the version changed from a "1" to a "2". > > also when I use the "up arrow" (within the 3.2.0 version) to retreve the last > command [it doesn't work] > I used to compile the command-line client using GNU readline so that the arrow keys would work. But a lot of users complained that readline didn't work on their systems because their system didn't have the right libraries installed. And in fact, when I recently upgraded to SuSE 9.2 (from RedHat 7.2) I found that SuSE is missing GNU readline. (SuSE is missing a lot of other stuff too, I've found.) So my latest builds do not have readline support. If somebody can suggest a simple readline facility that can be statically linked and which is easy to support, I be happy to start using it. -- D. Richard Hipp <[EMAIL PROTECTED]>
