qstring assignment crashes the program

[rahulvishwakarma]

as you said I build non-static fuction as follows

bool product_record::product_search(int numb)//, product_record *prdRecord)
{
    QString sql = "select * from tableProductRecords where number = ?";
    QSqlQuery qry;
    qry.prepare(sql);
 
    qry.bindValue(0, numb);
 
    if(qry.exec())
    {
        if(qry.next()) 
        {
            this->name = qry.value(0).toString(); // still program crashes here
            this->stock = qry.value(1).toInt();
            this->rate = qry.value(2).toInt();
            this->number = qry.value(3).toInt();
	    return true;
        }
    return false;
    }
 
 
}

bool product_record::product_search(int numb)//, product_record *prdRecord)
{
    QString sql = "select * from tableProductRecords where number = ?";
    QSqlQuery qry;
    qry.prepare(sql);

    qry.bindValue(0, numb);

    if(qry.exec())
    {
        if(qry.next()) 
        {
            this->name = qry.value(0).toString(); // still program crashes here
            this->stock = qry.value(1).toInt();
            this->rate = qry.value(2).toInt();
            this->number = qry.value(3).toInt();
	    return true;
        }
    return false;
    }

    
}

To copy to clipboard, switch view to plain text mode 

and called in this :-

void dialogAddNewRecord::on_pushButtonSearchByNumber_clicked()
{
    QString str = ui->lineEditNumber->text().trimmed();
    int s = str.toInt();
    prdRecord = new product_record(this);
 
    if(s)
    {
        prdRecord->product_search(s);
        ui->lineEditName->setText(prdRecord->text_name());
        ui->lineEditStock->setText(QString::number(prdRecord->text_stock()));
        ui->lineEditRate->setText(QString::number(prdRecord->text_rate()));
        ui->lineEditNumber->setText(QString::number(prdRecord->text_number()));
    }
    else
    {
        QMessageBox::information(this, "on_pushButtonSearchByNumber_clicked", "number not valid");
    }
 
}

void dialogAddNewRecord::on_pushButtonSearchByNumber_clicked()
{
    QString str = ui->lineEditNumber->text().trimmed();
    int s = str.toInt();
    prdRecord = new product_record(this);

    if(s)
    {
        prdRecord->product_search(s);
        ui->lineEditName->setText(prdRecord->text_name());
        ui->lineEditStock->setText(QString::number(prdRecord->text_stock()));
        ui->lineEditRate->setText(QString::number(prdRecord->text_rate()));
        ui->lineEditNumber->setText(QString::number(prdRecord->text_number()));
    }
    else
    {
        QMessageBox::information(this, "on_pushButtonSearchByNumber_clicked", "number not valid");
    }

}

To copy to clipboard, switch view to plain text mode 

[Lesiok]

Change line :

this->name = qry.value(0).toString(); // still program crashes here

this->name = qry.value(0).toString(); // still program crashes here

To copy to clipboard, switch view to plain text mode 

for this lines :

QString test = qry.value(0).toString(); // still program crashes here
this->name = test;

QString test = qry.value(0).toString(); // still program crashes here
this->name = test;

To copy to clipboard, switch view to plain text mode 

What is happening now ?

[rahulvishwakarma]

thanks a lot you solved my problem i did llike this

QString name =  qry.value(0).toString();
            this->name = name;
 
            int n = qry.value(1).toInt();
            this->stock =  n;
 
            float r = qry.value(2).toInt();
            this->rate =  r;
 
            int number = qry.value(3).toInt();
            this->number =  number;

QString name =  qry.value(0).toString();
            this->name = name;
            
            int n = qry.value(1).toInt();
            this->stock =  n;

            float r = qry.value(2).toInt();
            this->rate =  r;

            int number = qry.value(3).toInt();
            this->number =  number;

To copy to clipboard, switch view to plain text mode 

but i don't get the point how is it happening, Please explain.

[Lesiok]

It makes no sense to me.
By the way.
1. You are not guaranteed that a SELECT * query will return the record columns in the specified order. Either construct the query by explicitly entering the column names or retrieve the values later via QSqlRecord and field names.

2. There should be no toFloat() on line number 7 ?