UPDATE MAIN_DB_PREFIXpropaldet 
		SET special_code=104777
		, label=(SELECT label FROM MAIN_DB_PREFIXmilestone WHERE elementtype='propal' AND fk_element=MAIN_DB_PREFIXpropaldet.rowid)
		, qty=1
	 WHERE special_code=1790;<br />UPDATE MAIN_DB_PREFIXpropaldet 
		SET fk_parent_line=0
	 WHERE 1;<br />UPDATE MAIN_DB_PREFIXfacturedet 
		SET special_code=104777
		, label=(SELECT label FROM MAIN_DB_PREFIXmilestone WHERE elementtype='facture' AND fk_element=MAIN_DB_PREFIXfacturedet.rowid)
		,qty=1
	 WHERE special_code=1790;<br />UPDATE MAIN_DB_PREFIXfacturedet 
		SET fk_parent_line=0
	 WHERE 1;<br />UPDATE MAIN_DB_PREFIXcommandedet 
		SET special_code=104777
		, label=(SELECT label FROM MAIN_DB_PREFIXmilestone WHERE elementtype='commande' AND fk_element=MAIN_DB_PREFIXcommandedet.rowid)
		,qty=1
	 WHERE special_code=1790;<br />UPDATE MAIN_DB_PREFIXcommandedet 
		SET fk_parent_line=0
	 WHERE 1;<br />