details: https://code.openbravo.com/erp/devel/pi/rev/25cd2b136ddd
changeset: 16593:25cd2b136ddd
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Mon May 21 17:54:12 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 | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diffs (11 lines):
diff -r c00d43ad77bd -r 25cd2b136ddd
src-db/database/model/triggers/C_PERIOD_TRG2.xml
--- a/src-db/database/model/triggers/C_PERIOD_TRG2.xml Mon May 21 17:38:07
2012 +0200
+++ b/src-db/database/model/triggers/C_PERIOD_TRG2.xml Mon May 21 17:54:12
2012 +0200
@@ -59,6 +59,7 @@
SELECT COUNT(*) INTO V_COUNT
FROM C_PERIOD
WHERE C_PERIOD_ID <> :NEW.C_PERIOD_ID
+ AND AD_ORG_ID = :NEW.AD_ORG_ID
AND :NEW.STARTDATE <= ENDDATE
AND :NEW.ENDDATE >= STARTDATE;
IF (V_COUNT > 0) THEN
------------------------------------------------------------------------------
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
