QSqlQuery problem

[dragon]

I don't understand what you mean with assign en contents.
Can you give me a little example?.
Thank in advance.

[wysota]

I don't understand what you mean with assign en contents.
Can you give me a little example?

Here you assign to the variable called name:

name = (query.value(0).toString());

name = (query.value(0).toString());

To copy to clipboard, switch view to plain text mode 

If you want to make a search you need something like this:

while ( query.next() )
  if(name == query.value(0).toString()){
    leFirst->setText( name );
    break;
  }
}

while ( query.next() )
  if(name == query.value(0).toString()){
    leFirst->setText( name );
    break;
  }
}

To copy to clipboard, switch view to plain text mode 

Do you see the difference?

[dragon]

Yes i see the differents.
It works fine.
Thak you for your time and answer.

[wysota]

Of course it would be simpler to do it this way:

void MainWindow::search() {
  searchDialog dlg(this);
  if( dlg.exec() == QDialog::Accepted)  {
    QSqlQuery query;
    query.prepare("SELECT firstname FROM person WHERE firstname==:name");
    query.bindValue(":name", dlg.nameComboBox->currentText());
    if(query.exec() && query.hasNext())
      leFirst->setText( name);
  }
}

void MainWindow::search() {
  searchDialog dlg(this);
  if( dlg.exec() == QDialog::Accepted)  {
    QSqlQuery query;
    query.prepare("SELECT firstname FROM person WHERE firstname==:name");
    query.bindValue(":name", dlg.nameComboBox->currentText());
    if(query.exec() && query.hasNext())
      leFirst->setText( name);
  }
}

To copy to clipboard, switch view to plain text mode