details: https://code.openbravo.com/erp/devel/pi/rev/c00d43ad77bd
changeset: 16592:c00d43ad77bd
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Mon May 21 17:38:07 2012 +0200
summary: Fixes issue 20336: Should not be possible
to create several periods for same date range in different years.
diffstat:
src-db/database/model/triggers/C_PERIOD_TRG2.xml | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diffs (16 lines):
diff -r 1b61503d7d6a -r c00d43ad77bd
src-db/database/model/triggers/C_PERIOD_TRG2.xml
--- a/src-db/database/model/triggers/C_PERIOD_TRG2.xml Mon May 21 16:57:34
2012 +0200
+++ b/src-db/database/model/triggers/C_PERIOD_TRG2.xml Mon May 21 17:38:07
2012 +0200
@@ -56,7 +56,11 @@
IF (:NEW.STARTDATE > :NEW.ENDDATE) THEN
RAISE_APPLICATION_ERROR(-20000, '@DatesWrong@');
END IF;
- SELECT COUNT(*) INTO V_COUNT FROM C_PERIOD WHERE C_PERIOD_ID <>
:NEW.C_PERIOD_ID AND C_YEAR_ID = :NEW.C_YEAR_ID AND :NEW.STARTDATE <= ENDDATE
AND :NEW.ENDDATE >= STARTDATE;
+ SELECT COUNT(*) INTO V_COUNT
+ FROM C_PERIOD
+ WHERE C_PERIOD_ID <> :NEW.C_PERIOD_ID
+ AND :NEW.STARTDATE <= ENDDATE
+ AND :NEW.ENDDATE >= STARTDATE;
IF (V_COUNT > 0) THEN
RAISE_APPLICATION_ERROR(-20000, '@DatesOverlapped@');
END IF;
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
