Is there any way to determine the sqlite version either before opening the database, or immediately after? For example, if I update my application to v3.x, I would like to detect when a user tries to open a v2.x database, and then perhaps convert it to the new v3 compatible format.
Off the top of my head I can't think of a way to do it easily. I guess in the end I would need to include both versions of the sqlite db engine inside the application, in order to do a conversion from 2.x to 3.x.. Randall Fox On Mon, 19 Jul 2004 09:08:47 -0400, you wrote: >George Ionescu wrote: > > > > I think I have found another way to corrupt an sqlite database: create it > > with v3.0.2, add some data, open it with v2.8.14 and then try to open it back > > with v3.0.2. > > > >I tried this. 2.8.14 says "Unable to open database "test.db": file >is encrypted or is not a database". Then I try 3.0.2 again and it >works fine. > >Please tell me again exactly what you are doing?
