i am building small project, in Qt 5.7(on client) and mysql( on server). then in following program I stuck in "QMYSQLResult::data: column 1 out of range" problem. please help how to get rid of this.
Qt Code:
  1. void Sales::on_comboBoxName_currentTextChanged(const QString &arg1)
  2. {
  3. QString sql = "select productID, Rate, Stock from tableProductRecords where productname Like '%"+arg1+ "%';";
  4. query->prepare(sql);
  5. if(query->exec(sql))
  6. {
  7. if(query->next())
  8. {
  9. ui->lineEditProductNumber->setText(query->value(0).toString().trimmed());
  10. qDebug() << "ui->lineEditProductNumber->text().trimmed();" << ui->lineEditProductNumber->text().trimmed();
  11. QString str1 = query->value(1).toString().trimmed();
  12.  
  13. ui->lineEditRate->setText(str1); // here is error of column out of range
  14. qDebug() <<" ui->lineEditRate->text().trimmed(); " << ui->lineEditRate->text().trimmed();
  15. QString str2 = query->value(2).toString().trimmed();
  16. ui->lineEditStock->setText(str2);// here is error of column out of range
  17. qDebug() <<"ui->lineEditStock->text().trimmed();" << ui->lineEditStock->text().trimmed();
  18. }
  19. }
  20. }
To copy to clipboard, switch view to plain text mode 
output :-
Qt Code:
  1. ui->lineEditProductNumber->text().trimmed(); "1"
  2.  
  3. QMYSQLResult::data: column 1 out of range
  4.  
  5. ui->lineEditRate->text().trimmed(); ""
  6.  
  7. QMYSQLResult::data: column 2 out of range
  8. ui->lineEditStock->text().trimmed(); ""
  9.  
  10. ui->lineEditProductNumber->text().trimmed(); "1"
  11.  
  12. ui->lineEditRate->text().trimmed(); "7000"
  13. ui->lineEditStock->text().trimmed(); "4"
To copy to clipboard, switch view to plain text mode 
how do I get rid of "column out of range".