QComboBox, model and other values - how to get them?

[zuberek]

Hello!

First of all, Im new here, so I just want to say Hi to everybody

Ok, here is my problem.

Look at this code:

QSqlQueryModel *modelClientsList = new QSqlQueryModel;
    modelClientsList->setQuery("SELECT client_id, client_fullName, client_city, client_street, client_code, client_nip, client_regon, client_contactName, client_phone, client_fax, client_url, client_email, client_notes FROM scm_clients");
    modelClientsList->setHeaderData(0, Qt::Horizontal, QObject::trUtf8("ID"));
    modelClientsList->setHeaderData(1, Qt::Horizontal, QObject::trUtf8("Name"));
    modelClientsList->setHeaderData(2, Qt::Horizontal, QObject::trUtf8("City"));

QSqlQueryModel *modelClientsList = new QSqlQueryModel;
    modelClientsList->setQuery("SELECT client_id, client_fullName, client_city, client_street, client_code, client_nip, client_regon, client_contactName, client_phone, client_fax, client_url, client_email, client_notes FROM scm_clients");
    modelClientsList->setHeaderData(0, Qt::Horizontal, QObject::trUtf8("ID"));
    modelClientsList->setHeaderData(1, Qt::Horizontal, QObject::trUtf8("Name"));
    modelClientsList->setHeaderData(2, Qt::Horizontal, QObject::trUtf8("City"));

To copy to clipboard, switch view to plain text mode 

AND

ui->clientComboBox->setModel(modelClientsList);
    ui->clientComboBox->setModelColumn(1);
    ui->clientComboBox->setCurrentIndex(-1);

ui->clientComboBox->setModel(modelClientsList);
    ui->clientComboBox->setModelColumn(1);
    ui->clientComboBox->setCurrentIndex(-1);

To copy to clipboard, switch view to plain text mode 

AND

void StackedWidget::on_clientComboBox_currentIndexChanged(int index)
{
    qDebug() << ui->clientComboBox->itemData(index);
    qDebug() << ui->clientComboBox->itemData(currentIndex()).toString();
}

void StackedWidget::on_clientComboBox_currentIndexChanged(int index)
{
    qDebug() << ui->clientComboBox->itemData(index);
    qDebug() << ui->clientComboBox->itemData(currentIndex()).toString();
}

To copy to clipboard, switch view to plain text mode 

What I want to do is when I choose something from comboBox it should automatically put values (i.e. client_fullName, client_city, client_street ...) into lineEdit positions.
And here is the question: How can I get other values set by model from comboBox?

Second thing is, I use the very same model for displaying data in QTableView and it works fine. I use QStackedWidget for displaying whole stuff. I have a "new invoice" button next to the QTableView. Question: How to set QComboBox position to be the same as selected position from QTableView?

I tried to pass var CurrentClientId (which is client_id from database), but QComboBox provides default autoincrement values for positions in combobox. So CurrentClientId from QTableView is not the same as currentIndex() from QComboBox.

I hope I've explained everything clearly and You can understand what my problem is :-)

EDIT:
Q1: I guess I can make it work by adding items one by one in while(...) loop using addItem(name, id) and then querying each position separately, but it doesn't feels right. Any hint?

Thanks for any help!

Cheers!

[zuberek]

Ok, I managed to do it another way.

I made query (select name & id from DB) and I used "while" loop to put everything in ComboBox using addItem(name, id).
And then I used function on_comboBox_currentIndexChanged(int index) which exec another query and get all necessary values from DB (get id from itemData(currentIndex()) ) and setText to all lineEdit positions.

It works, but I dont like the way I did it. I think I connect to DB too many times, but I have no idea how to do it another way.

Second problem is also solved. I just used this ->

ui->comboBox->setCurrentIndex(ui->comboBox->findData(CurrentClientId));

ui->comboBox->setCurrentIndex(ui->comboBox->findData(CurrentClientId));

To copy to clipboard, switch view to plain text mode 

As I said, problem is solved, but I think there should be nicer way of doing this. If anybody have another solution it would be nice to share