--- Andrea Federico <[EMAIL PROTECTED]> wrote:
> 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: How big is the database file in the filesystem after you do this? Can you post it (the database file)? Have you defined any preprocessor macros when compiling, for example SQLITE_DEFAULT_AUTOVACUUM or one of the OMIT symbols? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
