details: /erp/devel/pi/rev/433ad8e1d1cf
changeset: 11518:433ad8e1d1cf
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Wed Apr 06 11:48:50 2011 +0200
summary: Fixes trigger for auxiliar inputs that checks DB Prefix
diffstat:
src-db/database/model/triggers/AD_AUXILIARINPUT_TRG.xml | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diffs (24 lines):
diff -r e2b1940ef8da -r 433ad8e1d1cf
src-db/database/model/triggers/AD_AUXILIARINPUT_TRG.xml
--- a/src-db/database/model/triggers/AD_AUXILIARINPUT_TRG.xml Wed Apr 06
11:14:54 2011 +0200
+++ b/src-db/database/model/triggers/AD_AUXILIARINPUT_TRG.xml Wed Apr 06
11:48:50 2011 +0200
@@ -19,14 +19,19 @@
* Contributor(s): ______________________________________.
************************************************************************/
v_aux NUMBER;
+ v_MODULE_ID AD_MODULE.AD_MODULE_ID%TYPE;
BEGIN
IF AD_isTriggerEnabled()='N' THEN RETURN;
END IF;
+ SELECT AD_MODULE_ID
+ INTO v_MODULE_ID
+ FROM AD_TAB WHERE AD_TAB_ID = :new.AD_TAB_ID;
- IF :new.AD_Module_ID != '0' THEN
+ IF (:new.AD_Module_ID != '0' AND :new.AD_MODULE_ID <> v_MODULE_ID) THEN
+
SELECT COUNT(*)
INTO v_Aux
FROM AD_MODULE_DBPREFIX
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
