details: https://code.openbravo.com/erp/devel/pi/rev/8a76c7f83af7
changeset: 17773:8a76c7f83af7
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Mon Aug 27 12:22:17 2012 +0200
summary: issue 19405: Error when you try to change a period's name in Oracle
Now the trigger filter by client and the error with org '0' is avoided
diffstat:
src-db/database/model/triggers/C_PERIOD_TRG3.xml | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diffs (11 lines):
diff -r 85cd0be35ad8 -r 8a76c7f83af7
src-db/database/model/triggers/C_PERIOD_TRG3.xml
--- a/src-db/database/model/triggers/C_PERIOD_TRG3.xml Tue Jul 31 13:12:27
2012 +0200
+++ b/src-db/database/model/triggers/C_PERIOD_TRG3.xml Mon Aug 27 12:22:17
2012 +0200
@@ -39,6 +39,7 @@
From C_Period
Where C_Period_Id <> Cur_Period.C_Period_Id
And Ad_Org_Id=Cur_Period.Ad_Org_Id
+ And Ad_Client_Id=Cur_Period.Ad_Client_Id
And Cur_Period.startdate <= Enddate
And Cur_Period.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
