details: /erp/devel/pi/rev/3eee3bd161cf
changeset: 10322:3eee3bd161cf
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Wed Feb 02 14:17:42 2011 +0100
summary: Fixes issue 0015566: bankstatement in a wrong status: it is not
processed and debt payments are cancelled
It has been added a condition in the C_BANKSTATEMENT trigger that verifies when
saving that there has not been running process concurrently
diffstat:
src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diffs (15 lines):
diff -r 8fe7281223e1 -r 3eee3bd161cf
src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml
--- a/src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml Wed Feb
02 13:42:34 2011 +0100
+++ b/src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml Wed Feb
02 14:17:42 2011 +0100
@@ -31,6 +31,11 @@
IF AD_isTriggerEnabled()='N' THEN RETURN;
END IF;
+ IF ((:OLD.PROCESSED = 'Y' AND :OLD.PROCESSING = 'N' AND :NEW.PROCESSED =
'N' AND :NEW.PROCESSING='N') OR
+ (:OLD.PROCESSED = 'N' AND :OLD.PROCESSING = 'N' AND :NEW.PROCESSED =
'Y' AND :NEW.PROCESSING='N')) THEN
+ -- Checking for concurrent process running
+ RAISE_APPLICATION_ERROR(-20501, '@OtherProcessActive@') ;
+ END IF;
IF UPDATING THEN
IF (:old.Processed='Y'
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
