details: /erp/devel/pi/rev/9d6e030418f7
changeset: 11831:9d6e030418f7
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Mon May 02 19:37:57 2011 +0200
summary: Fixes bug 16968: WAD validation for auxiliar inputs should be
modified
diffstat:
src-wad/src/org/openbravo/wad/validation/WADValidator_data.xsql | 22 +++++----
1 files changed, 12 insertions(+), 10 deletions(-)
diffs (32 lines):
diff -r 52fc57cffc6b -r 9d6e030418f7
src-wad/src/org/openbravo/wad/validation/WADValidator_data.xsql
--- a/src-wad/src/org/openbravo/wad/validation/WADValidator_data.xsql Mon May
02 18:38:58 2011 +0200
+++ b/src-wad/src/org/openbravo/wad/validation/WADValidator_data.xsql Mon May
02 19:37:57 2011 +0200
@@ -263,16 +263,18 @@
<Sql>
<![CDATA[
select i.name as objectName, (select max(name)
- from AD_Module_DBPrefix p
- where p.AD_Module_ID = i.AD_Module_ID)
as expectedvalue, m.name as moduleName, m.ad_module_id as moduleId
- from ad_auxiliarInput i, AD_Module m
- where i.ad_module_id != '0'
- and m.ad_module_id = i.ad_module_id
- and exists (select 1
- from AD_Module_DBPrefix p
- where p.AD_Module_ID = i.AD_Module_ID
- and instr(upper(i.NAME), upper(p.name)||'_') != 1)
- and (m.javapackage in ('1') or to_char('Y')=to_char(?))
+ from AD_Module_DBPrefix p
+ where p.AD_Module_ID = i.AD_Module_ID) as
expectedvalue
+ from ad_auxiliarInput i, AD_Module m, AD_Tab t
+ where i.ad_module_id != '0'
+ and m.ad_module_id = i.ad_module_id
+ and t.ad_tab_id = i.ad_tab_id
+ and t.ad_module_id <> i.ad_module_id
+ and exists (select 1
+ from AD_Module_DBPrefix p
+ where p.AD_Module_ID = i.AD_Module_ID
+ and instr(upper(i.NAME), upper(p.name)||'_') != 1)
+ and (m.javapackage in ('1') or to_char('Y')=to_char(?))
]]>
</Sql>
<Field name="objecttype" value=""/>
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
