数据库用的sqlite,sql语句在Navicat里运行是有用的,但在Qt用query.exec()就报错了
query_In.exec("INSERT into homepage(MName,MType,Manufacturer,ChangeNumber,Price,MFlag,Date,Human)"
"select MName,MType,Manufacturer,ChangeNumber,Price,MFlag,Date,Human"
"from InOut");
if(query_In.exec())
{
model_InOut->clear();
QSqlRecord record = model_InOut->record();
int row = model_InOut->rowCount();
model_InOut->insertRecord(row, record);
}
else
{
qDebug() << "cuowu:" << query_In.lastError();
QMessageBox::critical(this,tr("错误"),
tr("入库失败!"),
tr("确定"));
}
这是Qt里的代码。
cuowu: QSqlError("", "Unable to fetch row", "No query")