details: http://code.openbravo.com/erp/devel/pi/rev/680613ab71fa
changeset: 3542:680613ab71fa
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Tue Apr 07 14:55:06 2009 +0200
summary: fixed bug 0008486: Not possible to add a value in 'Skin list'
reference within a module
diffstat:
src-db/database/model/triggers/AD_REF_LIST_TRG.xml | 15 ++++++++++-----
src-db/database/sourcedata/AD_COLUMN.xml | 1 +
2 files changed, 11 insertions(+), 5 deletions(-)
diffs (43 lines):
diff -r 19ffaf793fb0 -r 680613ab71fa
src-db/database/model/triggers/AD_REF_LIST_TRG.xml
--- a/src-db/database/model/triggers/AD_REF_LIST_TRG.xml Tue Apr 07
05:17:14 2009 -0400
+++ b/src-db/database/model/triggers/AD_REF_LIST_TRG.xml Tue Apr 07
14:55:06 2009 +0200
@@ -33,18 +33,23 @@
IF AD_isTriggerEnabled()='N' THEN RETURN;
END IF;
-
+ --In case the value is in a different module than its reference check the
value
+ --starts with that module's dbprefix or in case it is a value for skins list
+ --it starts with the module's java package.
SELECT count(*)
INTO v_Aux
- FROM AD_REFERENCE R,
- AD_PACKAGE M
+ FROM AD_REFERENCE R
WHERE R.AD_REFERENCE_ID = :new.AD_REFERENCE_ID
- AND R.AD_MODULE_ID = M.AD_Module_ID
AND R.AD_MODULE_ID != :new.AD_Module_ID
AND NOT EXISTS (SELECT 1
FROM AD_MODULE_DBPREFIX P
WHERE P.AD_MODULE_ID = :new.AD_Module_ID
- AND instr(upper(:new.value), upper(P.name)||'_') = 1);
+ AND instr(upper(:new.value), upper(P.name)||'_') = 1)
+ AND NOT (:new.AD_REFERENCE_ID = '800102'
+ AND EXISTS (SELECT 1
+ FROM AD_MODULE M2
+ WHERE M2.AD_MODULE_ID = :NEW.AD_MODULE_ID
+ AND instr(upper(:new.VALUE),
upper(M2.JAVAPACKAGE))=1));
IF v_Aux != 0 THEN
RAISE_APPLICATION_ERROR(-20536, 'Names must start with its module''s DB
prefix') ;
diff -r 19ffaf793fb0 -r 680613ab71fa src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Tue Apr 07 05:17:14 2009 -0400
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Tue Apr 07 14:55:06 2009 +0200
@@ -260387,6 +260387,7 @@
<!--605B65500DC8E13BE040007F01002829-->
<COLUMNNAME><![CDATA[AD_Module_ID]]></COLUMNNAME>
<!--605B65500DC8E13BE040007F01002829-->
<AD_TABLE_ID><![CDATA[104]]></AD_TABLE_ID>
<!--605B65500DC8E13BE040007F01002829-->
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--605B65500DC8E13BE040007F01002829-->
<AD_VAL_RULE_ID><![CDATA[C45CFD74FF5145B0A356E9233D49996F]]></AD_VAL_RULE_ID>
<!--605B65500DC8E13BE040007F01002829-->
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
<!--605B65500DC8E13BE040007F01002829--> <DEFAULTVALUE><![cda...@sql=select
AD_MODULE_ID FROM AD_REFERENCE WHERE AD_REFERENCE_ID =
@ad_reference...@]]></DEFAULTVALUE>
<!--605B65500DC8E13BE040007F01002829--> <ISKEY><![CDATA[N]]></ISKEY>
------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
