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

Support for substituting one column with multiple values through QSqlRelationalTableModel

XMLWordPrintable

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

      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.

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

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

              Created:
              Updated:
              Resolved:

                There are no open Gerrit changes