select all is now working

[anda_skoa]

how check the QSqlQuery?

Earlier you posted code that iterates through a query result, no?

When I check number of rows in the model using "qDebug() << model->rowCount();" it returns 0 in console.

Then it will be interesting to see if the query works directly.
Because it looks like there is no data for that query.

how to compate values of the rows with the values from the query?

Well, since your model says it has 0 rows there is no data to compare.

Cheers,
_

[godlesplay]

So I have no idea why tableWidget can obtain my data from my database and tableView not.

[anda_skoa]

The table widget does not obtain data, you are iterating over a query object there.
And the code you posted for the table widget case was a different then the one you tried with the query model.

Cheers,
_

[godlesplay]

So I found another method to obtain data from db http://wklej.to/4MWsN but it returns values from 1st row, how can I obtain other data?

[anda_skoa]

You could read the documentation of QSqlQuery, it even comes with an example.

Cheers,
_