Loading data from sqlite database

Kushan

In my simple Qt c++ application I want to load a set of names from the user table in my sqlite database on to a table view upon a button click. Though the database connection is successfully opened nothing gets loaded to the tableview.

following is my code

void MainWindow::on_pushButton_2_clicked()
{
mydb = QSqlDatabase::addDatabase("QSQLITE");
mydb.setDatabaseName("C:/Users/User/Desktop/Qt/Perf.db");
if(!mydb.open()){
ui->label->setText("Cant open DB");
}
else{
ui->label->setText("DB successfully opened");
}
QSqlQueryModel* modal = new QSqlQueryModel();
QSqlQuery *qry = new QSqlQuery(mydb);
qry->prepare("Select * FROM SER_MESAGES");
qry->exec();
modal->setQuery(*qry);
ui->tableView->setModel(modal);

}

How can I fix this problem?

dream_captain

@Kushan
Check the results of prepare() and exec()

bool prepRet = qry->prepare("Select * FROM SER_MESAGES");
if (!prepRet) {
     qDebug() << qry->lastError().text();
     return;
}
if (!qry->exec()) {
     qDebug() << qry->lastError().text();
    return;
}

Kushan

@dream_captain I get the message "file is encrypted or is not a database Unable to execute statement""in the console

dream_captain

@Kushan
Maybe database file is corrupted, or maybe it's a SQLite 2 database. Most likely it's not Qt-related.

Kushan

@dream_captain no Its sqlite3!

dream_captain

@Kushan
Try to open it in database manager (sqlite studio or something like that)

mrjj

Try to open it in database manager (sqlite studio or something like that)

I can highly recommend this
http://sqlitebrowser.org/

SGaist

Hi,

What was used to create that database ?

Did it use the SEE (SQLite Encryption Extension) ?

Kushan

@SGaist Thanx got it solved

SGaist

What was the problem ?