📄 c_conversion_rate_trg.sql
字号:
CREATE OR REPLACE TRIGGER C_Conversion_Rate_Trg
BEFORE INSERT OR UPDATE
ON C_Conversion_Rate
FOR EACH ROW
DECLARE
/*************************************************************************
* The contents of this file are subject to the Compiere License. You may
* obtain a copy of the License at http://www.compiere.org/license.html
* Software is on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
* express or implied. See the License for details. Code: Compiere ERP+CRM
* Copyright (C) 1999-2002 Jorg Janke, ComPiere, Inc. All Rights Reserved.
*************************************************************************
* $Id: C_Conversion_Rate_Trg.sql,v 1.3 2002/10/08 13:25:46 jjanke Exp $
***
* Title: Set ToDate
* Description:
* If there is no valid ToDate set it to arbitrary end date
************************************************************************/
BEGIN
IF (:new.ValidTo IS NULL) THEN
-- If there is no end date, set it to X
:new.ValidTo := TO_DATE ('29-JAN-2056', 'DD-MON-YYYY', 'NLS_DATE_LANGUAGE=American');
END IF;
END C_Conversion_Rate_Trg;
/
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -