[SOLVED] SQLite database stays closed.

Ravenblack

I am trying to work with databases in Qt and I cant seem to find the problem in my code.

@
string currDir = get_current_dir_name();

db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName( QString::fromStdString( currDir + "\\XmatoData.sqlite" ) );

if (!db.open())
{
    QMessageBox msgBox;
    msgBox.setWindowTitle( "Xmato Database Error" );
    msgBox.setInformativeText( "Database is not connected. Error: " + db.lastError().text()  );
    msgBox.setWindowModality( Qt::ApplicationModal );
    msgBox.setStandardButtons( QMessageBox::Ok );
    msgBox.exec&#40;&#41;;
}
else
{
    QMessageBox msgBox;
    msgBox.setWindowTitle( "Xmato Success" &#41;;
    msgBox.setInformativeText( "Database is connected." );
    msgBox.setWindowModality( Qt::ApplicationModal );
    msgBox.setStandardButtons( QMessageBox::Ok );
    msgBox.exec&#40;&#41;;
}

@

That code gives no errors...

Then when I prepare a quary:
@
if( db.isOpen() )
{
query.prepare( QString::fromStdString( _quary )
}
@

I get a runtime error that says:
@
QSqlQuery::prepare: database not open
@

_quary is a valid quary.

Any ideas? Thanks.

Ravenblack

Okay, I found the solution..

I uninstalled Qt
Downloaded the tarball (.tar.gz file containing the source code for Qt (Windows users use the .zip file)).
Configure with this command:
@
./configure -plugin-sql-sqlite
@

or
@
./configure -qt-sql-sqlite
@

If it gives you some shit about qtwebkits use just add the following to the configure command:
@
-skip qtwebkit
@

make and install with this commands:
@
make
@

after a few frieking hours, then
@
sudo make install
@

Now this is very important:
when you declare QSqlQuery, declare it after you added the driver, i.e.:
@
QSqlDatabase db;
db = QSqlDatabase::addDatabase( "QSQLITE" );
if( db.open() )
{
QSqlQuery query; //NOTE THIS IS AFTER THE addDatabase("QSQLITE") FUNCTION!
}
@

If for some reason you need the query to be declared earlier (like in a class) do this:
@
QSqlDatabase db;
QSqlQuery query;

//This is in another part of the code
db = QSqlDatabase::addDatabase( "QSQLITE" );
if( db.open() )
{
QSqlQuery tmp;
query = tmp;
}
@