Qt问题添加表小部件项目

debugcn 发表于 Dev

根0x

我有一个发票表格，我可以用来创建发票和显示已存储发票的结果。我在尝试从数据库中读取数据并显示它时出现以下错误：

QTableWidget：无法插入已由另一个QTableWidget拥有的项目QTableWidget：无法插入已由另一个QTableWidget拥有的项目QTableWidget：无法插入已由另一个QTableWidget拥有的项目QTableWidget：无法插入已被另一个QTableWidget拥有的项目另一个QTableWidget QTableWidget：无法插入另一个QTableWidget已拥有的项目

我不明白为什么这是原因。我尝试运行的查询将返回4行。我的代码如下

QString CompanyID;
            int row = 0;
            ui->comboBox_Invoice_Account_Search->setCurrentIndex(1);
            QSqlQuery Account_Name_Query;
            QTableWidgetItem *Qty_Search = new QTableWidgetItem();
            QTableWidgetItem *Description_Search = new QTableWidgetItem();
            QTableWidgetItem *Product_Code_Search = new QTableWidgetItem();
            QTableWidgetItem *Unit_Price_Search = new QTableWidgetItem();
            QTableWidgetItem *Total_Price_Search = new QTableWidgetItem();
            while(Query.next())
            {
                CompanyID = Query.value(10).toString();
                //qDebug() << "CompanyID " << CompanyID;
                ui->lineEdit_Invoice_VAT->setText(Query.value(9).toString());
                ui->lineEdit_Invoice_Total->setText(Query.value(8).toString());
                ui->lineEdit_Goods_Total->setText(Query.value(7).toString());
                Qty_Search->setText(Query.value(3).toString());
                Description_Search->setText(Query.value(4).toString());
                Product_Code_Search->setText(Query.value(5).toString());
                Unit_Price_Search->setText(Query.value(6).toString());
                Total_Price_Search->setText(Query.value(7).toString());
                ui->tableWidget_Invoice->setItem(row, 0, Qty_Search);
                ui->tableWidget_Invoice->setItem(row, 1, Description_Search);
                ui->tableWidget_Invoice->setItem(row, 2, Product_Code_Search);
                ui->tableWidget_Invoice->setItem(row, 3, Unit_Price_Search);
                ui->tableWidget_Invoice->setItem(row, 4, Total_Price_Search);
                row++;
                Account_Name_Query.prepare("SELECT Company_Name FROM Customer WHERE Company_ID = '"+ CompanyID +"'");
                Account_Name_Query.exec();
                while(Account_Name_Query.next())
                {
                    ui->lineEdit_Invoice_Account->setText(Account_Name_Query.value(0).toString());
                }
            }

是什么导致此错误？

斯拉夫索夫

这是因为您试图将在循环外创建的相同项目多次设置到同一表中。将您的代码更改为：

while(Query.next())
{
    QTableWidgetItem *Qty_Search = new QTableWidgetItem();
    QTableWidgetItem *Description_Search = new QTableWidgetItem();
    QTableWidgetItem *Product_Code_Search = new QTableWidgetItem();
    QTableWidgetItem *Unit_Price_Search = new QTableWidgetItem();
    QTableWidgetItem *Total_Price_Search = new QTableWidgetItem();

    ...
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。