QSqlTableModel/QSqlQueryModel

[dragon]

I have one thing about setFilter.
Normally the use of setFilter is this: model.setFilter("Materiaal = 'Koolstofstaal'"); and this works fine.
Have anybody try this with a bigger string:
model.setFilter("Materiaal = 'Koolstofstaal' and Materiaal = 'Gelegeerdstaal' and Materiaal = 'Gereeedshapstaal'");
If i try this there nothing showing up in my lineEdits.
I want put this strings together to make a choice of a item in my combobox.
thanks in advance.

[jpn]

Try "or" instead of "and"...

[dragon]

I have tried model.setFilter("Materiaal = 'Koolstofstaal' or Materiaal = 'Gelegeerdstaal'or Materiaal = 'Gereedschapstaal'");
With no succes it shows only the first string Materiaal = 'Koolstofstaal'

[jacek]

What value does model.rowCount() return after setFilter() and select()?

[dragon]

This a part of the code.
void MainWindow::search()
{
searchDialog dlg(this)
QString mat = dlg.leMateriaalComboBox->currentText()
if(dlg.exec() == QDialog::Accepted) {

QSqltableModel model;
model.setTable("frezen");
model.setFilter("Materiaal ='Koolstofstaal' or Materiaal = 'Gelegeerdstaal' or Materiaal = 'Gereedschapstaal'");
model.select();

for (int i = 0; i < model.rowCount(); ++i) {
mat = model.record(i).value("Materiaal").toString();
leMateriaal->setText(mat);
}
}
The value from model.rowCount() is only the first part of the setFilter string ( Koolstofstaal ) the orther value's doesn't show up in the lineEdit in Mainwindow.

[jacek]

model.setFilter("Materiaal ='Koolstofstaal' or Materiaal = 'Gelegeerdstaal' or Materiaal = 'Gereedschapstaal'");
...
mat = model.record(i).value("Materiaal").toString();

Do you really need a model for this? It seems you know a priori what values you want to display (i.e. "Koolstofstaal", "Gelegeerdstaal" and "Gereedschapstaal").

the orther value's doesn't show up in the lineEdit in Mainwindow.

QLineEdit::setText() sets the text --- it doesn't append it.

lineEdit->setText( "aaa" ); // after this line lineEdit will contain "aaa"
lineEdit->setText( "bbb" ); // now "aaa" is replaced by "bbb"

lineEdit->setText( "aaa" ); // after this line lineEdit will contain "aaa"
lineEdit->setText( "bbb" ); // now "aaa" is replaced by "bbb"

To copy to clipboard, switch view to plain text mode 

If you want to display several values, concatenate them.

But I think that you would rather want to use a QComboBox instead of QLineEdit.

[dragon]

Yes i want to use in searchDialog the combobox.
Maby i chance the code for this program.
Thanks jacek voor your time and answers.