void Impostazioni::ResetDbCoefCombinaz()
{
	SQL & Delete(COEFCOMBIN);
	
	int i=0;
	Progress p(t_("Creating database: coefficienti di combinazione..."));
	
	try
	{
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Carichi permanenti"))(PSI0j,0)(PSI1j,0)(PSI2j,0); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Carichi permanenti NON strutturali"))(PSI0j,0)(PSI1j,0)(PSI2j,0); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Categoria A Ambienti ad uso residenziale"))(PSI0j,0.70)(PSI1j,0.50)(PSI2j,0.30); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Categoria B Uffici"))(PSI0j,0.70)(PSI1j,0.50)(PSI2j,0.30); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Categoria C Ambienti suscettibili di affollamento"))(PSI0j,0.70)(PSI1j,0.70)(PSI2j,0.60); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Categoria D Ambienti ad uso commerciale"))(PSI0j,0.70)(PSI1j,0.70)(PSI2j,0.60); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Categoria E Biblioteche, archivi, magazzini e ambienti ad uso industriale"))(PSI0j,1.00)(PSI1j,0.90)(PSI2j,0.80); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Categoria F Rimesse e parcheggi (per autoveicoli di peso <= 30 kN)"))(PSI0j,0.70)(PSI1j,0.70)(PSI2j,0.60); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Categoria G Rimesse e parcheggi (per autoveicoli di peso > 30 kN)"))(PSI0j,0.70)(PSI1j,0.50)(PSI2j,0.30); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Categoria H Coperture"))(PSI0j,0.00)(PSI1j,0.00)(PSI2j,0.00); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Vento"))(PSI0j,0.60)(PSI1j,0.20)(PSI2j,0.00); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Neve (a quota <= 1000 m s.l.m.)"))(PSI0j,0.50)(PSI1j,0.20)(PSI2j,0.00); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Neve (a quota > 1000 m s.l.m.)"))(PSI0j,0.70)(PSI1j,0.50)(PSI2j,0.20); p.SetPos(++i);
		SQL & Insert(COEFCOMBIN)(CATEGORIA,t_("Variazioni termiche"))(PSI0j,0.60)(PSI1j,0.50)(PSI2j,0.00); p.SetPos(++i);
	}
	catch(SqlExc &e)
	{
		Exclamation("[* " + DeQtfLf(e) + "]");
	}
}

double Impostazioni::GetPsi0j(String s)
{
	SQL * Select(PSI0j).From(COEFCOMBIN).Where(CATEGORIA == s);	return SQL[PSI0j];
}