View with 3 column remove row work with 4 column dont work with 5 cant edit
Hi
Table Pracownicy
Code:
| Pracownicy | CREATE TABLE `Pracownicy` (
`IDPracownika` int(11) NOT NULL AUTO_INCREMENT,
`IDStanowiska` int(11) DEFAULT NULL,
`Imie` char(20) NOT NULL,
`Nazwisko` char(20) NOT NULL,
`DataUrodzenia` date DEFAULT NULL,
`Ulica` char(20) DEFAULT NULL,
`NrDomu` char(10) DEFAULT NULL,
`KodPocztowy` char(5) DEFAULT NULL,
`Miasto` char(20) DEFAULT NULL,
`DataZatrudnienia` date DEFAULT NULL,
`DataZwolnienia` date DEFAULT NULL,
`Pensja` float DEFAULT NULL,
PRIMARY KEY (`IDPracownika`),
KEY `FK_R1` (`IDStanowiska`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1
View
Code:
CREATE VIEW V1 AS
SELECT IDPracownika,Imie,Nazwisko
FROM Pracownicy
CREATE VIEW V2 AS
SELECT IDPracownika,Imie,Nazwisko,IDStanowiska
FROM Pracownicy
CREATE VIEW V3 AS
SELECT IDPracownika,Imie,Nazwisko,IDStanowiska,DataUrodzenia
FROM Pracownicy
Qt Code
Code:
Part 1) //Selecting Table
Login to DB ....
model.setTable("V1");
model.select();
table.setModel(&model);
table.show();
Part 2) //Delete rows
QModelIndexList t_SelectedRow = table.selectionModel()->selectedRows();
model.removeRow(i.row());
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 ??
Re: View with 3 column remove row work with 4 column dont work with 5 cant edit
I have solutnion, i cant remove row if some column is empty (if all column in view have data then i can delete row).
WHY ????
Re: View with 3 column remove row work with 4 column dont work with 5 cant edit
Somebody know, why if columns IDStanowiska or DataUrodzenia is emplt (have Value NULL) then cant delete this row ??
Columns Imie and Nazwisko can by emplty, because they are NOT NULL and MySQL automatically add empty String .
Somebody Know how delete row if in View exist column how have NULL value ??
Re: View with 3 column remove row work with 4 column dont work with 5 cant edit
online nich chat thienthien_bk