Update of /cvsroot/compiere/db/maintain/Translation
In directory usw-pr-cvs1:/tmp/cvs-serv8896/maintain/Translation
Modified Files:
Translation_Copy.sql
Added Files:
DeleteLanguage.sql
Log Message:
.
--- NEW FILE: DeleteLanguage.sql ---
/*************************************************************************
* The contents of this file are subject to the Compiere License. You may
* obtain a copy of the License at http://www.compiere.org/license.html
* Software is on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
* express or implied. See the License for details. Code: Compiere ERP+CRM
* Copyright (C) 1999-2002 Jorg Janke, ComPiere, Inc. All Rights Reserved.
*************************************************************************
* $Id: DeleteLanguage.sql,v 1.1 2002/07/30 05:51:59 jjanke Exp $
***
* Title: Delete Language
* Description:
************************************************************************/
DECLARE
CURSOR Cur_Tables IS
SELECT TableName
FROM AD_Table
WHERE TableName like '%_Trl';
v_Cmd VARCHAR2(256);
BEGIN
FOR t IN CUR_Tables LOOP
v_Cmd := 'DELETE ' || t.TableName || ' WHERE AD_Language=''fr_FR''';
DBMS_OUTPUT.PUT_LINE('.. ' || v_Cmd);
EXECUTE IMMEDIATE v_Cmd;
END LOOP;
END;
/
COMMIT
/
Index: Translation_Copy.sql
===================================================================
RCS file: /cvsroot/compiere/db/maintain/Translation/Translation_Copy.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** Translation_Copy.sql 28 Jul 2002 02:45:27 -0000 1.1
--- Translation_Copy.sql 30 Jul 2002 05:51:59 -0000 1.2
***************
*** 189,192 ****
--- 189,194 ----
WHERE t.AD_Workbench_ID=tt.AD_Workbench_ID AND t.AD_Language=tt.AD_Language);
+ -------------------------------------------------------------------------------
+
-- C_DocType
UPDATE C_DocType_Trl t
***************
*** 199,202 ****
--- 201,212 ----
WHERE t.C_DocType_ID=tt.C_DocType_ID AND t.AD_Language=tt.AD_Language);
+ UPDATE C_DocType_Trl t
+ SET (AD_Client_ID,AD_Org_ID,Name,PrintName,DocumentNote) =
+ (SELECT AD_Client_ID,AD_Org_ID,Name,PrintName,DocumentNote
+ FROM C_DocType d WHERE t.C_DocType_ID=d.C_DocType_ID)
+ WHERE EXISTS
+ (SELECT * FROM C_DocType d WHERE t.C_DocType_ID=d.C_DocType_ID);
+
+
-- C_DunningLevel
UPDATE C_DunningLevel_Trl t
***************
*** 209,212 ****
--- 219,230 ----
WHERE t.C_DunningLevel_ID=tt.C_DunningLevel_ID AND t.AD_Language=tt.AD_Language);
+ UPDATE C_DunningLevel_Trl t
+ SET (AD_Client_ID,AD_Org_ID,PrintName,Note) =
+ (SELECT AD_Client_ID,AD_Org_ID,tt.PrintName,tt.Note
+ FROM C_DunningLevel tt WHERE t.C_DunningLevel_ID=tt.C_DunningLevel_ID)
+ WHERE EXISTS
+ (SELECT * FROM C_DunningLevel tt WHERE t.C_DunningLevel_ID=tt.C_DunningLevel_ID);
+
+
-- C_ElementValue
UPDATE C_ElementValue_Trl t
***************
*** 219,222 ****
--- 237,249 ----
WHERE t.C_ElementValue_ID=tt.C_ElementValue_ID AND t.AD_Language=tt.AD_Language);
+ UPDATE C_ElementValue_Trl t
+ SET (AD_Client_ID,AD_Org_ID,Name,Description) =
+ (SELECT AD_Client_ID,AD_Org_ID,tt.Name,tt.Description
+ FROM C_ElementValue tt
+ WHERE t.C_ElementValue_ID=tt.C_ElementValue_ID)
+ WHERE EXISTS
+ (SELECT * FROM C_ElementValue tt WHERE t.C_ElementValue_ID=tt.C_ElementValue_ID);
+
+
-- C_Greeting
UPDATE C_Greeting_Trl t
***************
*** 229,232 ****
--- 256,268 ----
WHERE t.C_Greeting_ID=tt.C_Greeting_ID AND t.AD_Language=tt.AD_Language);
+ UPDATE C_Greeting_Trl t
+ SET (AD_Client_ID,AD_Org_ID,Name,Greeting) =
+ (SELECT AD_Client_ID,AD_Org_ID,tt.Name,tt.Greeting
+ FROM C_Greeting tt
+ WHERE t.C_Greeting_ID=tt.C_Greeting_ID)
+ WHERE EXISTS
+ (SELECT * FROM C_Greeting tt WHERE t.C_Greeting_ID=tt.C_Greeting_ID);
+
+
-- C_PaymentTerm
UPDATE C_PaymentTerm_Trl t
***************
*** 239,242 ****
--- 275,287 ----
WHERE t.C_PaymentTerm_ID=tt.C_PaymentTerm_ID AND t.AD_Language=tt.AD_Language);
+ UPDATE C_PaymentTerm_Trl t
+ SET (AD_Client_ID,AD_Org_ID,Name,Description,DocumentNote) =
+ (SELECT AD_Client_ID,AD_Org_ID,tt.Name,tt.Description,tt.DocumentNote
+ FROM C_PaymentTerm tt
+ WHERE t.C_PaymentTerm_ID=tt.C_PaymentTerm_ID)
+ WHERE EXISTS
+ (SELECT * FROM C_PaymentTerm tt WHERE t.C_PaymentTerm_ID=tt.C_PaymentTerm_ID);
+
+
-- C_TaxCategory
UPDATE C_TaxCategory_Trl t
***************
*** 249,252 ****
--- 294,306 ----
WHERE t.C_TaxCategory_ID=tt.C_TaxCategory_ID AND t.AD_Language=tt.AD_Language);
+ UPDATE C_TaxCategory_Trl t
+ SET (AD_Client_ID,AD_Org_ID,Name,Description) =
+ (SELECT AD_Client_ID,AD_Org_ID,tt.Name,tt.Description
+ FROM C_TaxCategory tt
+ WHERE t.C_TaxCategory_ID=tt.C_TaxCategory_ID)
+ WHERE EXISTS
+ (SELECT * FROM C_TaxCategory tt WHERE t.C_TaxCategory_ID=tt.C_TaxCategory_ID);
+
+
-- C_UOM
UPDATE C_UOM_Trl t
***************
*** 258,261 ****
--- 312,324 ----
AND EXISTS (SELECT * FROM jjanke.C_UOM_Trl tt
WHERE t.C_UOM_ID=tt.C_UOM_ID AND t.AD_Language=tt.AD_Language);
+
+ UPDATE C_UOM_Trl t
+ SET (AD_Client_ID,AD_Org_ID,Name,Description,UOMSymbol) =
+ (SELECT AD_Client_ID,AD_Org_ID,tt.Name,tt.Description,tt.UOMSymbol
+ FROM C_UOM tt
+ WHERE t.C_UOM_ID=tt.C_UOM_ID)
+ WHERE EXISTS
+ (SELECT * FROM C_UOM tt WHERE t.C_UOM_ID=tt.C_UOM_ID);
+
/**
|
