Qt SQLite

Hi, i'm doing a little aplication in qt that insert data in a SQLite, in my pc it's ok but in other pc's the aplication don't insert the data :s

The aplication: http://dl.dropbox.com/u/6416035/release.zip

The code:

Code:

---

#include "mainwindow.h"
#include <QSqlDatabase>
#include <QDebug>
#include <QSqlQuery>
#include <QSqlError>
#include <QSqlTableModel>
#include <QTableView>
#include <QString>
#include <QDir>
#include <QFileDialog>
#include <QMessageBox>
#include <QSqlRecord>
#include <QLabel>
#include <QProgressBar>
#include <QLayout>
#include <QVBoxLayout>
#include <QTimer>
 
MainWindow::MainWindow(QWidget *parent)
    : QMainWindow(parent)
{
 
        QString dir = QFileDialog::getOpenFileName(this, tr("Open Directory"),"");//,tr("SQLite (*.*)"));
        //qDebug()<<dir;
        QString path(dir);
        //path.append(QDir::separator()).append("dbpass");
        path = QDir::toNativeSeparators(path);
        //qDebug()<<path;
        //db.setDatabaseName(path);
 
        db = QSqlDatabase::addDatabase("QSQLITE");
        //db.setDatabaseName("thomsonkeysDB");
        db.setDatabaseName(path);
 
        if (db.open()) {
            // Try to locate the contacts database.
            // If it is not available create it.
            if (db.tables().indexOf("thomsonkeys") == -1) {
                QSqlQuery query(db);
                query.prepare("CREATE TABLE thomsonkeys (ssid VARCHAR(6), pass VARCHAR(10))");
                if (!query.exec())
                    qCritical() << query.lastError();
            }
        } else {
            qCritical() << db.lastError();
        }
 
    QVBoxLayout *layout = new QVBoxLayout;
    progresso = new QProgressBar;
    progresso->setMaximum(174680046);
    layout->addWidget(progresso);
 
    QWidget *w=new QWidget();
    w->setLayout(layout);
    this->setCentralWidget(w);
 
 
    QTimer::singleShot(100, this, SLOT(teste()));
}
 
MainWindow::~MainWindow()
{
 
}
 
void MainWindow::teste(){
    QString dir = QFileDialog::getOpenFileName(this, tr("Open Directory"),"",tr("Texto (*.txt)"));
    QFile f(dir);
    f.open(QIODevice::ReadOnly);
    if(f.isOpen())
    {
        QSqlQuery query(db);
 
        int step=174680046/100;
        int bytesProcessed=0;
        QString linha;
        QStringList list;
        progresso->setValue(bytesProcessed);
        while (not f.atEnd()){
            linha = f.readLine().data();
            bytesProcessed+= linha.size();
            list = linha.split(":");
            query.exec("insert into thomsonkeys values('"+list.at(0)+"', '"+list.at(1)+"')");
            if (bytesProcessed%step<=10){
                qDebug()<<"bytesProcessed:"<<bytesProcessed;
                progresso->setValue(bytesProcessed);
            }
        }
        progresso->setValue(bytesProcessed);
 
    }
    else
    {
        QMessageBox::warning(this,"Erro","Sem ficheiro com as passwords!");
    }
}

---

What is the error you get from your query? Also you should consider using prepare() to avoid a potential security leak because of SQL injection.

I discover that the problem is that the sqlite file wasn't created :S

Thankyou. I used your database creation/open technique to create the SQLite file on the harddisk and it is working very fine.