On 16/04/06 [EMAIL PROTECTED] said: > 3.3.5 is backwards compatible. It will read and write a 3.2.2 > database file. But 3.2.2 is not forwards compatible to 3.3.5. > > SQLite 3 will always be backwards compatible. Forwards compatibility > is a goal but is not guaranteed.
Ah, right. > If you compile 3.3.5 with -DSQLITE_DEFAULT_FILE_FORMAT=1 then it > will by default generate a database that 3.2.2 can read. You can > do this at runtime using > > PRAGMA legacy_file_format=ON; > > Do the pragma when creating the database before the first CREATE TABLE. Thanks, I'll keep that in mind. Being subscribed to this list will hopefully keep me more informed of such changes in the future. Mike -- Michael P. Soulier <[EMAIL PROTECTED]> "Any intelligent fool can make things bigger and more complex... It takes a touch of genius - and a lot of courage to move in the opposite direction." --Albert Einstein
pgpwewHKPbpg2.pgp
Description: PGP signature