[Openbravo-commits] openbravo [5084] fixed bug 0003976: Identifier for parameters in action button

[svn-commit]

Revision: 5084
          https://dev.openbravo.com/websvn/openbravo/?rev=5084&sc=1
Author:   alostale
Date:     2008-06-17 10:24:15 +0200 (Tue, 17 Jun 2008)

Log Message:
-----------
fixed bug 0003976: Identifier for parameters in action button are not taken 
with the column with seqno=1 but the lowest one set as identifier

Ticket Links:
:-----------
    http://issues.openbravo.com/view.php?id=0003976

Modified Paths:
--------------
    trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql
    trunk/src-wad/src/org/openbravo/wad/datasource.xsqlxml

Modified: trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql
===================================================================
--- trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql        2008-06-17 
07:59:04 UTC (rev 5083)
+++ trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql        2008-06-17 
08:24:15 UTC (rev 5084)
@@ -367,7 +367,14 @@
         SELECT MAX(columnname) AS NAME FROM AD_COLUMN, AD_TABLE 
         WHERE AD_TABLE.NAME = ?
           AND AD_COLUMN.ad_table_id = AD_TABLE.ad_table_id
-          AND isidentifier = 'Y' AND SeqNo = (CASE TO_CHAR(AD_TABLE.NAME) WHEN 
'C_PaySelectionCheck' THEN 2 ELSE 1 END)
+          AND isidentifier = 'Y' 
+          AND SeqNo = (CASE TO_CHAR(AD_TABLE.NAME) 
+                          WHEN 'C_PaySelectionCheck' THEN 2 
+                          ELSE (SELECT MIN(SeqNo) 
+                                  FROM AD_Column 
+                                 WHERE AD_Table_ID=AD_TABLE.AD_Table_ID 
+                                   AND IsIdentifier='Y')
+                           END)
       </Sql>
       <Parameter name="tableName"/>
   </SqlMethod>

Modified: trunk/src-wad/src/org/openbravo/wad/datasource.xsqlxml
===================================================================
--- trunk/src-wad/src/org/openbravo/wad/datasource.xsqlxml      2008-06-17 
07:59:04 UTC (rev 5083)
+++ trunk/src-wad/src/org/openbravo/wad/datasource.xsqlxml      2008-06-17 
08:24:15 UTC (rev 5084)
@@ -188,7 +188,7 @@
 
 <FIELDS_TMP id="sectionActionSearchs">
    &#60;SqlMethod name="selectActDef<PARAMETER_TMP 
id="params12">table</PARAMETER_TMP>" type="preparedStatement" return="String" 
default=""&#62;
-    &#60;SqlMethodComment&#62;Select for auxiliar 
field&#60;/SqlMethodComment&#62;
+    &#60;SqlMethodComment&#62;Select for action 
search&#60;/SqlMethodComment&#62;
     &#60;Sql&#62;&#60;&#33;[CDATA[
         <PARAMETER_TMP id="Select12">select</PARAMETER_TMP> 
     ]]&#62;&#60;/Sql&#62;



-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits