What is the best way to display a Join between 2 or 3 tables? QSqlQueryModel?
-
I want to display a join of 2 or more tables selecting which columns I want to display and in what order...
Is QSqlQueryModel the way ... is there an example?@jdent
Yes,QSqlQueryModelis the way to do this.Don't know what you need an "example" for --- just call
setQuery()with whatever query you want, presumably includingJOIN(s), what else is there to say? If you really want do a Google forqsqlquerymodel joinand have a look through some of the matches. -
@jdent
Yes,QSqlQueryModelis the way to do this.Don't know what you need an "example" for --- just call
setQuery()with whatever query you want, presumably includingJOIN(s), what else is there to say? If you really want do a Google forqsqlquerymodel joinand have a look through some of the matches. -
J jdent has marked this topic as solved on
-
@JonB Ok, I thought there was more explicit support for joins, but it appears we only place the query string and that's it
Thanks anyway!
@jdent said in What is the best way to display a Join between 2 or 3 tables? QSqlQueryModel?:
Ok, I thought there was more explicit support for joins
Yes, there isn't :) Qt provides low-ish level support for database table access, nothing fancy, nothing for an arbitrary
JOIN. The only "extra" is QSqlRelationalTableModel Class, which implements a specificJOINfor a foreign key. There will be third-party code, e.g. KDAB, out there which builds another layer on top if you want it.
