Fixes bug 11434 Error when you modify a Spanish's Bank.
authorVinoth Babu <vinoth.babu@openbravo.com>
Mon, 18 Jan 2010 18:10:13 +0530
changeset 5889 a24f43cb19a0
parent 5888 13b41e0dce07
child 5890 ad62f64f097e
Fixes bug 11434 Error when you modify a Spanish's Bank.
src-db/database/model/triggers/C_BANKCOUNTRY_TRG.xml
--- a/src-db/database/model/triggers/C_BANKCOUNTRY_TRG.xml	Mon Jan 18 12:09:54 2010 +0100
+++ b/src-db/database/model/triggers/C_BANKCOUNTRY_TRG.xml	Mon Jan 18 18:10:13 2010 +0530
@@ -30,7 +30,7 @@
 
   --  Default Accounts for all AcctSchema
   IF(UPDATING) THEN
-    IF (:NEW.C_COUNTRY_ID <> :OLD.C_COUNTRY_ID OR :NEW.C_COUNTRY_ID IS NULL) THEN
+    IF (:NEW.C_LOCATION_ID <> :OLD.C_LOCATION_ID OR :NEW.C_LOCATION_ID IS NULL) THEN
       SELECT COUNT(IBAN)
       INTO v_Count
       FROM C_BANKACCOUNT