Hi
Table Pracownicy
Qt Code:
  1. | Pracownicy | CREATE TABLE `Pracownicy` (
  2. `IDPracownika` int(11) NOT NULL AUTO_INCREMENT,
  3. `IDStanowiska` int(11) DEFAULT NULL,
  4. `Imie` char(20) NOT NULL,
  5. `Nazwisko` char(20) NOT NULL,
  6. `DataUrodzenia` date DEFAULT NULL,
  7. `Ulica` char(20) DEFAULT NULL,
  8. `NrDomu` char(10) DEFAULT NULL,
  9. `KodPocztowy` char(5) DEFAULT NULL,
  10. `Miasto` char(20) DEFAULT NULL,
  11. `DataZatrudnienia` date DEFAULT NULL,
  12. `DataZwolnienia` date DEFAULT NULL,
  13. `Pensja` float DEFAULT NULL,
  14. PRIMARY KEY (`IDPracownika`),
  15. KEY `FK_R1` (`IDStanowiska`)
  16. ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1
To copy to clipboard, switch view to plain text mode 

View
Qt Code:
  1. CREATE VIEW V1 AS
  2. SELECT IDPracownika,Imie,Nazwisko
  3. FROM Pracownicy
  4.  
  5. CREATE VIEW V2 AS
  6. SELECT IDPracownika,Imie,Nazwisko,IDStanowiska
  7. FROM Pracownicy
  8.  
  9. CREATE VIEW V3 AS
  10. SELECT IDPracownika,Imie,Nazwisko,IDStanowiska,DataUrodzenia
  11. FROM Pracownicy
To copy to clipboard, switch view to plain text mode 

Qt Code
Qt Code:
  1. Part 1) //Selecting Table
  2. Login to DB ....
  3.  
  4. model.setTable("V1");
  5. model.select();
  6.  
  7. QTableView table;
  8. table.setModel(&model);
  9. table.show();
  10.  
  11. Part 2) //Delete rows
  12. QModelIndexList t_SelectedRow = table.selectionModel()->selectedRows();
  13. foreach(QModelIndex i, t_SelectedRow)
  14. model.removeRow(i.row());
To copy to clipboard, switch view to plain text mode 
So, why delete work on V1 but on V2 dont work ??
In V1 and V2 edit rows work but in V3 delete row and edit dont work
Why ??