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/
