Hi sqliteUsers, I have a simple question:
can you tell me why I obtain an error creating a simple table in a new database ? if I insert this simple command: sqlite> create table tbl1(one varchar(10), two smallint); sqlite> PRAGMA integrity_check; *** in database main *** Page 2 is never used I obtain "Page 2 is never used" , I don't understand this strange behaviuor and if I dump the database: sqlite> .dump BEGIN TRANSACTION; CREATE TABLE tbl1(one varchar(10), two smallint); COMMIT; I dont' see where is the the problem. If i try to insert some vales into the table I have an error again: sqlite> insert into tbl1 values('hello!',10); SQL error: database disk image is malformed have you some idea to solve the problem? Best Regards Andrea Federico -- ___________________________________________________ Play 100s of games for FREE! http://games.mail.com/