Hello Nahor,

there is no need for you to use SQLiteSpy 1.4 to create SQLite 3.2.x compatible 
database files. You can do so with the latest version of SQLiteSpy as well. 
Here's how to do so:

1. Create a new database as usual.

2. Execute the following two SQL statements:

   PRAGMA legacy_file_format = 1;
   VACUUM;

3. The database is in 3.2.x format again. 

4. Work with the database as usual, but do not "VACUUM" 
   it without the legacy_file_format = 1.

Btw, the not only applies to SQLiteSpy but to SQLite 3.3.x in general.

Regards,

Ralf

>My application is currently using 3.2. If I create the db using
>SQLiteSpy 1.5, it create one in the 3.3 format, making it unreadable by
>my app. When I noticed the problem, I wanted to revert to SQLiteSpy 1.4
>but it's not available on your website anymore  :(

Reply via email to