int row;
open conn...
qry.prepare("select rowid from my_table");
qry.exec();
while(qry.next()){
if(something==something2)
row=qry.value(0).toInt();
}
close conn...
open conn...
qry.prepare("UPDATE my_table"
"SET some=:some"
"WHERE rowid=:row");
qry.bindValue(":some", some);
qry.bindValue(":row",row);
if(qry.exec()){
...
close conn...
}
else{
QMessageBox::critical(this,tr
("error::"),qry.
lastError().
text());
close conn...
}
int row;
open conn...
QSqlQuery qry;
qry.prepare("select rowid from my_table");
qry.exec();
while(qry.next()){
if(something==something2)
row=qry.value(0).toInt();
}
close conn...
QString some;
open conn...
qry.prepare("UPDATE my_table"
"SET some=:some"
"WHERE rowid=:row");
qry.bindValue(":some", some);
qry.bindValue(":row",row);
if(qry.exec()){
...
close conn...
}
else{
QMessageBox::critical(this,tr("error::"),qry.lastError().text());
close conn...
}
To copy to clipboard, switch view to plain text mode
i rly don't understand what am i doing wrong...
note that my sql connections are working fine, ...
i keep getting error "no query unable to fetch row"
Thanks
Bookmarks