Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-14

Support for substituting one column with multiple values through QSqlRelationalTableModel

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Out of scope
    • P3: Somewhat important
    • Some future release
    • 4.0.0
    • SQL Support
    • None

    Description

      Consider this setup:

      CREATE TABLE author 
      ( 
         id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
         firstname varchar(40) NOT NULL,
         surname varchar(40) NOT NULL
      );
      
      CREATE TABLE book 
      ( 
        id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
        title varchar(40),
        price numeric(10,2),
        authorid integer,
        notes varchar(255), 
        FOREIGN KEY (authorid) REFERENCES author(id)
      );
      

      I'd like to have the authorid replace with the firstname and surname from the
      author table. Currently there is no API to achieve this.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            mabrand Mark Brand
            sanonymous Nokia Qt Support (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes