details: https://code.openbravo.com/erp/devel/pi/rev/2971a8c0024c
changeset: 17781:2971a8c0024c
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Tue Aug 28 10:50:23 2012 +0200
summary: issue 19405: Error when you try to change a period's name in Oracle.
Now all periods are checked except Permanently closed
diffstat:
src-db/database/model/triggers/C_PERIOD_TRG3.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r d3245331b58a -r 2971a8c0024c
src-db/database/model/triggers/C_PERIOD_TRG3.xml
--- a/src-db/database/model/triggers/C_PERIOD_TRG3.xml Mon Aug 06 10:13:25
2012 +0200
+++ b/src-db/database/model/triggers/C_PERIOD_TRG3.xml Tue Aug 28 10:50:23
2012 +0200
@@ -33,7 +33,7 @@
Where C_Period_Id In (Select Distinct(Cp.C_Period_Id)
From C_Period Cp
Join C_Periodcontrol Cpc On Cpc.C_Period_Id= Cp.C_Period_Id
- Where Periodstatus = 'O'))
+ Where Periodstatus <> 'P'))
Loop
Select Count(*)
Into V_COUNT
------------------------------------------------------------------------------
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
