queryTxt = "DELIMITER  //";
		query.exec(queryTxt);
		err=query.lastError().text();
		query.finish();
		queryTxt= "CREATE TRIGGER `transitparams_trigger` BEFORE INSERT ON `transitparams` FOR EACH ROW BEGIN"
				"declare numberact, numberreport, numberresolution, numberfillinform int;"
				"if (new.category <> '1') then"
				"SELECT transitparams.actnumber, transitparams.reportnumber, transitparams.resolutionnumber, transitparams.fillinformnumber into numberact,numberreport,numberresolution, numberfillinform"
				"FROM transitparams"
				"WHERE transitparams.paramid=(select max(transitparams.paramid) from transitparams where transitparams.category <> '1');"
				"if (numberact is null) then"
				"set new.actnumber=1;"
				"set new.reportnumber=1;"
				"set new.resolutionnumber=1;"
				"set new.fillinformnumber=1;"
				"else"
				"if(new.actnumber is null) then"
				"set	new.actnumber=numberact+1;"
				"end if;"
				"if (new.reportnumber is null) then"
				"set new.reportnumber=numberreport+1;"
				"end if;"
				"if (new.resolutionnumber is null) then"
				"set new.resolutionnumber=numberresolution+1;"
				"end if;"
				"if (new.fillinformnumber is null) then"
				"set new.fillinformnumber=numberfillinform+1;"
				"end if;"
				"end if;"
				"end if;"
				"END;";
bool done = query.exec(queryTxt);

queryTxt = "DELIMITER  //";
query.exec(queryTxt);