Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Overriding QSqlTableModel::select() for MyQSqlRelationalTableModel
QtWS25 Last Chance

Overriding QSqlTableModel::select() for MyQSqlRelationalTableModel

Scheduled Pinned Locked Moved General and Desktop
2 Posts 2 Posters 737 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    Mariusu
    wrote on last edited by
    #1

    By default inheritance looks like this: ...QSqlTableModel--QSqlRelationalTableModel

    The idea is to subclass QSqlTableModel and to override QSqlTableModel::select() method like that:

    d->clearCache();
    query.append(" LIMIT 10 "); //new line
    QSqlQuery qu(query, d->db);
    

    Also to subclass QSqlRelationalTableModel. But by subclassing QSqlRelationalTableModel it automatically inherits QSqlTableModel::select() not MyQSqlTableModel::select().

    Of course I could modify QSqlTableModel source and recompile, but this would limit portability. Is the any solution? I would like to set the number of rows to return by model.

    1 Reply Last reply
    0
    • SGaistS Offline
      SGaistS Offline
      SGaist
      Lifetime Qt Champion
      wrote on last edited by
      #2

      Hi and welcome to devnet,

      Is it a limit that you really need on the SQL side or is it only to limit what you will be displaying ?

      Interested in AI ? www.idiap.ch
      Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

      1 Reply Last reply
      0

      • Login

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Users
      • Groups
      • Search
      • Get Qt Extensions
      • Unsolved