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. SQLite :: Unable to read sql view which has aggregate functions
Forum Updated to NodeBB v4.3 + New Features

SQLite :: Unable to read sql view which has aggregate functions

Scheduled Pinned Locked Moved General and Desktop
1 Posts 1 Posters 1.7k Views 1 Watching
  • 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.
  • A Offline
    A Offline
    Alin Glow
    wrote on 8 Apr 2012, 05:39 last edited by
    #1

    Hello.
    I have strange error when trying read view (SQlLite) whith aggregate functions to QSqlRelationalTableModel.
    QSqlRelationalTableModel->select() failed with message:
    "no such column: group_concat(trolleybus.id) Unable to execute statement"
    Similar error occurred when i try replace/link foreign key to show column "group_concat(trolleybus.id)" in QSqlRelation.
    SQLite:
    @CREATE VIEW [view_maintenance_trolleybus] AS
    SELECT maintenance.id, maintenance.name, group_concat(trolleybus.id)
    FROM maintenance
    LEFT OUTER JOIN
    trolleybus
    ON
    maintenance.id = trolleybus.maintenance_id
    GROUP BY maintenance.id;@

    Same SELECT works as intended in QSqlQueryModel.

    Qt: 4.8, Windows, msv2010

    1 Reply Last reply
    0

    1/1

    8 Apr 2012, 05:39

    • Login

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