details: https://code.openbravo.com/erp/stable/2.50/rev/8429ab9833a4
changeset: 9795:8429ab9833a4
user: Antonio Moreno <antonio.moreno <at> openbravo.com>
date: Tue Jan 17 12:53:59 2012 +0100
summary: Fixed issue 11528. Common columns will be imported with a correct
name
diffstat:
src-db/database/model/functions/AD_TABLE_IMPORT.xml | 28 +++++++++++++++++++-
1 files changed, 26 insertions(+), 2 deletions(-)
diffs (52 lines):
diff -r d4fc63700072 -r 8429ab9833a4
src-db/database/model/functions/AD_TABLE_IMPORT.xml
--- a/src-db/database/model/functions/AD_TABLE_IMPORT.xml Thu Jan 26
12:50:42 2012 +0100
+++ b/src-db/database/model/functions/AD_TABLE_IMPORT.xml Tue Jan 17
12:53:59 2012 +0100
@@ -63,6 +63,7 @@
v_IsUpdateable CHAR(1):='Y';
v_DefaultValue NVARCHAR2(2000):='';
v_SeqNo NUMBER(10) ;
+ v_columnNameOrg VARCHAR2(40) ;
v_columnName VARCHAR2(40) ;
v_TableName VARCHAR2(40) ;
v_LastColumnName VARCHAR2(40) ;
@@ -236,7 +237,30 @@
IF(v_columnName LIKE '%_Id') THEN
v_columnName:=SUBSTR(v_columnName, 1, LENGTH(v_columnName) -3) ||'_ID';
END IF;
-
+ -- Some columns need to have specific names for DAL to work correctly:
+ v_columnNameOrg:=v_columnName;
+ IF(v_columnName = 'AD_Org_ID') THEN
+ v_columnName:='Organization';
+ END IF;
+ IF(v_columnName = 'AD_Client_ID') THEN
+ v_columnName:='Client';
+ END IF;
+ IF(v_columnName = 'Created') THEN
+ v_columnName:='Creation Date';
+ END IF;
+ IF(v_columnName = 'Createdby') THEN
+ v_columnName:='Created By';
+ END IF;
+ IF(v_columnName = 'Updated') THEN
+ v_columnName:='Updated';
+ END IF;
+ IF(v_columnName = 'Updatedby') THEN
+ v_columnName:='Updated By';
+ END IF;
+ IF(v_columnName = 'Isactive') THEN
+ v_columnName:='Active';
+ END IF;
+
--Check if it is necessary to recalculate positions
SELECT count(*)
INTO v_Aux
@@ -287,7 +311,7 @@
VALUES
(v_NextNo, '0', '0', 'Y',
now(), '0', now(), '0',
- v_columnName, v_columnName, Cur_Column.AD_Table_ID,
+ v_columnName,v_columnNameOrg, Cur_Column.AD_Table_ID,
v_AD_Reference_ID, v_FieldLength, v_IsKey, v_IsParent,
(CASE Cur_Column.Nullable WHEN 'Y' THEN 'N' ELSE 'Y' END),
v_IsIdentifier, v_SeqNo, 'N', 'N', v_IsUpdateable,
v_AD_Reference_Value_ID,
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
