details: /erp/devel/pi/rev/87b919ca8474
changeset: 11823:87b919ca8474
user: Stefan Hühner <stefan.huehner <at> openbravo.com>
date: Mon May 02 14:01:03 2011 +0200
summary: [cleanup] fix failing trigger, remove some access to removed table
- the ad_wf_* tables have been removed from pi but were still referenced those
triggers.
diffstat:
src-db/database/model/triggers/AD_PROCESS_TRG.xml | 1 -
src-db/database/model/triggers/AD_WINDOW_TRG.xml | 13 -------------
2 files changed, 0 insertions(+), 14 deletions(-)
diffs (34 lines):
diff -r e101d3e4b10a -r 87b919ca8474
src-db/database/model/triggers/AD_PROCESS_TRG.xml
--- a/src-db/database/model/triggers/AD_PROCESS_TRG.xml Mon May 02 13:17:23
2011 +0200
+++ b/src-db/database/model/triggers/AD_PROCESS_TRG.xml Mon May 02 14:01:03
2011 +0200
@@ -145,7 +145,6 @@
WHERE AD_Column_ID = (SELECT AD_Column_ID
FROM AD_Column
WHERE AD_Process_ID = :NEW.AD_Process_ID);
- -- AD_WF_Node
END IF;
END IF;
END IF;
diff -r e101d3e4b10a -r 87b919ca8474
src-db/database/model/triggers/AD_WINDOW_TRG.xml
--- a/src-db/database/model/triggers/AD_WINDOW_TRG.xml Mon May 02 13:17:23
2011 +0200
+++ b/src-db/database/model/triggers/AD_WINDOW_TRG.xml Mon May 02 14:01:03
2011 +0200
@@ -108,19 +108,6 @@
and AD_Menu_Trl.ad_language = m1.ad_language
and AD_Menu_Trl.ad_menu_id = ad_menu.ad_menu_id);
- IF (COALESCE(:old.IsActive, '.') <> COALESCE(:NEW.IsActive, '.')) THEN
- -- Update Workflow
- UPDATE AD_WF_Node
- SET IsActive=:new.IsActive
- WHERE AD_Window_ID=:new.AD_Window_ID;
- UPDATE AD_WF_Node
- SET Name=:new.Name,
- Description=:new.Description,
- Help=:new.Help
- WHERE AD_Window_ID=:new.AD_Window_ID
- AND IsCentrallyMaintained='Y';
- END IF;
-
-- Translation
UPDATE AD_Window_Trl
SET IsTranslated='N',
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
