RE: [sqlite] File format changed !!

2006-02-27 Thread Chethana, Rao \(IE10\)
Hi!

Just use select * from sqlite_master;




-Original Message-
From: Pavan Savoy [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 27, 2006 10:13 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] File format changed !!

I am trying to open a database created in  SQLite 3.3.1 in SQlite 3.1.2 
and I get the following err when I try to see the sqlite_master table ..

SQL error: unsupported file format


I suppose the file format has been changed over the versions, but the 
reverse does work, i.e db created on 3.1.2 can be opened on 3.3.1.



I just wanted some sort of document which suggests changes in file
format 
over the versions,  changes  page doesnt represent the full picture 
though




Thank you


Re: [sqlite] File format changed !!

2006-02-27 Thread Firman Wandayandi
On 2/28/06, Pavan Savoy [EMAIL PROTECTED] wrote:
 I am trying to open a database created in  SQLite 3.3.1 in SQlite 3.1.2
 and I get the following err when I try to see the sqlite_master table ..

 SQL error: unsupported file format


 I suppose the file format has been changed over the versions, but the
 reverse does work, i.e db created on 3.1.2 can be opened on 3.3.1.



 I just wanted some sort of document which suggests changes in file format
 over the versions,  changes  page doesnt represent the full picture
 though



http://sqlite.org/formatchng.html



 Thank you



--
Firman Wandayandi
Never Dreamt Before: http://firman.dotgeek.org/
Wishlist: http://www.amazon.com/gp/registry/1AAN8NZBHW2W9