ad_process_trl_trg.sql

来自「Java写的ERP系统」· SQL 代码 · 共 29 行

CREATE OR REPLACE TRIGGER AD_Process_Trl_Trg
AFTER UPDATE OF Name, Description, Help, IsTranslated 
	ON AD_Process_Trl
FOR	EACH ROW
/******************************************************************************
 * ** Compiere Product **             Copyright (c) 1999-2001 Accorto, Inc. USA
 * Open  Source  Software        Provided "AS IS" without warranty or liability
 * When you use any parts (changed or unchanged), add  "Powered by Compiere" to
 * your product name;  See license details http://www.compiere.org/license.html
 ******************************************************************************
 *	AD_Process_Trl update trigger
 *		synchronize name,... with	 Field if centrally	maintained
 */
BEGIN
	UPDATE AD_Field_Trl
	   SET Name	= :NEW.Name,
		   Description = :NEW.Description,
		   Help	= :NEW.Help,
		   IsTranslated	= :NEW.IsTranslated,
		   Updated = SysDate
	 WHERE AD_Language = :NEW.AD_Language
	   AND AD_Field_ID IN (SELECT F.AD_Field_ID
							 FROM AD_Field F, AD_Column	C
							WHERE F.AD_Column_ID = C.AD_Column_ID
							  AND C.AD_Process_ID = :new.AD_Process_ID
							  AND F.IsCentrallyMaintained =	'Y');
END	AD_Process_Trl_Trg;
/