details: https://code.openbravo.com/erp/devel/pi/rev/f91d12c55f35
changeset: 14037:f91d12c55f35
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Thu Oct 20 15:58:17 2011 +0200
summary: Fixes issue 0018646: The Create columns from table process does not
handle BYTEA columns
It has been added in the PL/SQL proccess AD_TABLE_IMPORT support for TEXT
(Postgresql) and CLOB (Oracle) data type
diffstat:
src-db/database/model/functions/AD_TABLE_IMPORT.xml | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diffs (21 lines):
diff -r 2c5f1b6d2be7 -r f91d12c55f35
src-db/database/model/functions/AD_TABLE_IMPORT.xml
--- a/src-db/database/model/functions/AD_TABLE_IMPORT.xml Thu Oct 20
12:36:58 2011 +0200
+++ b/src-db/database/model/functions/AD_TABLE_IMPORT.xml Thu Oct 20
15:58:17 2011 +0200
@@ -200,6 +200,8 @@
v_FieldLength:=COALESCE(Cur_Column.Data_Precision, 10) +2;
ELSIF(Cur_Column.Data_Type IN ('BYTEA', 'BLOB')) THEN
v_FieldLength:=4000;
+ ELSIF(Cur_Column.Data_Type IN ('TEXT', 'CLOB')) THEN
+ v_FieldLength:=1000000;
ELSE
v_FieldLength:=Cur_Column.Data_Length;
END IF;
@@ -222,6 +224,8 @@
v_AD_Reference_ID:='15';
ELSIF(Cur_Column.Data_Type IN ('BYTEA', 'BLOB')) THEN
v_AD_Reference_ID:='23';
+ ELSIF(Cur_Column.Data_Type IN ('TEXT', 'CLOB')) THEN
+ v_AD_Reference_ID:='14';
ELSE
v_AD_Reference_ID:='10'; -- if not found, use String
v_CorrectType:='N';
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Ciosco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
