PDA

View Full Version : SQLITTE "unable to fetch row"



giusepped
20th January 2009, 08:40
I have two database connections (SQLITE).
The second one is created by:


bool MainWindow::createConnection(const QString &id)
{
databasePanels = QCoreApplication::applicationDirPath()+"/panels.db";

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE",id);

db.setDatabaseName(databasePanels);
db.open();
/
if (db.isOpen())
return true;
else

return false;
}




void MainWindow::createTablePanel(const QString &type)
{
QSqlDatabase db=QSqlDatabase::database(type);
db.setDatabaseName(databasePanels);
QSqlQuery q(db);
q.prepare(" create table pannelli ( id INTEGER NOT NULL PRIMARY KEY,costruttore VARCHAR(50),modello VARCHAR(50),pnom )");
q.exec();

}

but I get:

createTablePanel.: QSqlError(-1, "Unable to fetch row", "No query") "

why?

spirit
20th January 2009, 09:05
maybe this table already exist?

nhs_0702
30th May 2010, 06:03
maybe this table already exist?

void MainWindow::on_pushButton_clicked()
{
QSqlDatabase db = QSqlDatabase::addDatabase( "QSQLITE" );
db.setDatabaseName( "C:/Users/BotNetVN/Desktop/TuDien/Disa.s3db" );
QSqlQuery qry;
QString qstrExe = "INSERT INTO word (ID_Word,English) VALUES (3,'" + ui->textEdit->toPlainText() + "')";
qry.prepare( qstrExe );
if (!qry.exec()){
ui->textEdit->setText(qry.lastError().text());
}
else{
ui->textEdit->setText("Them CSDL thanh cong");
}
db.close();
}

why error No query Unable to fetch row

ChrisW67
31st May 2010, 00:24
Where are you opening the database in MainWindow::on_pushButton_clicked()?