Trolltech Home | Qt-interest Home | Recent Threads | All Threads | Author | Date
All threads index page 2

Qt-interest Archive, April 2007
SQLITE Autovacuum

Message 1 in thread

How i can create AUTOVACUUM database, this DIDN'T work:

     db = QSqlDatabase::addDatabase(QLatin1String("QSQLITE"));
     db.setDatabaseName(QLatin1String("test.db3"));
         if (db.open())
         {
             QSqlQuery query(db);
             if (!query.exec("PRAGMA auto_vacuum = 0")) 
qDebug(qPrintable(query.lastError().text()));
         }

--
 [ signature omitted ]
Message 2 in thread

Sorry, me need more sleep :P
PRAGMA auto_vacuum = 1

SABROG пишет:
> How i can create AUTOVACUUM database, this DIDN'T work:
> 
>     db = QSqlDatabase::addDatabase(QLatin1String("QSQLITE"));
>     db.setDatabaseName(QLatin1String("test.db3"));
>         if (db.open())
>         {
>             QSqlQuery query(db);
>             if (!query.exec("PRAGMA auto_vacuum = 0")) 
> qDebug(qPrintable(query.lastError().text()));
>         }

--
 [ signature omitted ]