details:   https://code.openbravo.com/erp/devel/pi/rev/fd17b88f8379
changeset: 20729:fd17b88f8379
user:      Shankar Balachandran <shankar.balachandran <at> openbravo.com>
date:      Mon Jul 15 12:21:34 2013 +0530
summary:   Related to issue 20623 : Fix api checks
An additional argument was added to the Insert method in TabAttachments_data 
that failed api tests.
Added an additional sql method for insert to maintain backward compatibility.

diffstat:

 src/org/openbravo/erpCommon/businessUtility/TabAttachments_data.xsql |  23 
+++++++++-
 1 files changed, 22 insertions(+), 1 deletions(-)

diffs (36 lines):

diff -r 8362ae2c2b8f -r fd17b88f8379 
src/org/openbravo/erpCommon/businessUtility/TabAttachments_data.xsql
--- a/src/org/openbravo/erpCommon/businessUtility/TabAttachments_data.xsql      
Mon Jul 15 10:21:16 2013 +0530
+++ b/src/org/openbravo/erpCommon/businessUtility/TabAttachments_data.xsql      
Mon Jul 15 12:21:34 2013 +0530
@@ -96,10 +96,31 @@
         <Parameter name="adTabId"/>
    </SqlMethod>
    <SqlMethod name="insert" type="preparedStatement" connection="true" 
return="rowCount">
+      <SqlMethodComment>This method is depreciated. Use the insert method with 
path argument</SqlMethodComment>
+      <Sql> <![CDATA[
+        INSERT INTO C_FILE (C_FILE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, 
CREATED, CREATEDBY,
+        UPDATED, UPDATEDBY, AD_TABLE_ID, AD_RECORD_ID, C_DATATYPE_ID, TEXT, 
NAME, SEQNO)
+        VALUES(?, ?, ?, 'Y', now(), ?,
+        now(), ?, ?, ?, ?, ?, ?, (SELECT COALESCE(MAX(SEQNO), 0) + 10 FROM 
C_FILE WHERE AD_TABLE_ID = ? AND AD_RECORD_ID=?))
+      ]]></Sql>
+        <Parameter name="cFileId"/>
+        <Parameter name="adClientId"/>
+        <Parameter name="adOrgId"/>
+        <Parameter name="adUserId"/>
+        <Parameter name="adUserId"/>
+        <Parameter name="adTableId"/>
+        <Parameter name="adRecordId"/>
+        <Parameter name="cDatatypeId"/>
+        <Parameter name="text"/>
+        <Parameter name="name"/>
+        <Parameter name="adTableId"/>
+        <Parameter name="adRecordId"/>
+   </SqlMethod>
+   <SqlMethod name="insert" type="preparedStatement" connection="true" 
return="rowCount">
       <SqlMethodComment></SqlMethodComment>
       <Sql> <![CDATA[
         INSERT INTO C_FILE (C_FILE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, 
CREATED, CREATEDBY, 
-        UPDATED, UPDATEDBY, AD_TABLE_ID, AD_RECORD_ID, C_DATATYPE_ID, TEXT, 
NAME, SEQNO,PATH)
+        UPDATED, UPDATEDBY, AD_TABLE_ID, AD_RECORD_ID, C_DATATYPE_ID, TEXT, 
NAME, SEQNO, PATH)
         VALUES(?, ?, ?, 'Y', now(), ?, 
         now(), ?, ?, ?, ?, ?, ?, (SELECT COALESCE(MAX(SEQNO), 0) + 10 FROM 
C_FILE WHERE AD_TABLE_ID = ? AND AD_RECORD_ID=?),?)
       ]]></Sql>

------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to