src-trl/src/org/openbravo/translate/Translate_data.xsql
changeset 5935 89419c2a9a0c
parent 5067 e13fc21ebf9c
child 6701 690d2af86089
--- a/src-trl/src/org/openbravo/translate/Translate_data.xsql	Tue Jan 19 16:48:03 2010 +0100
+++ b/src-trl/src/org/openbravo/translate/Translate_data.xsql	Tue Jan 19 17:46:50 2010 +0100
@@ -12,7 +12,7 @@
  * under the License. 
  * The Original Code is Openbravo ERP. 
  * The Initial Developer of the Original Code is Openbravo SL 
- * All portions are Copyright (C) 2001-2006 Openbravo SL 
+ * All portions are Copyright (C) 2001-2010 Openbravo SL 
  * All Rights Reserved. 
  * Contributor(s):  ______________________________________.
  ************************************************************************
@@ -223,4 +223,16 @@
                         and m.isInDevelopment = 'Y')  
     </Sql>
   </SqlMethod>
+  
+  <SqlMethod name="remove" type="preparedStatement" return="rowCount">
+    <SqlMethodComment>Return the translation of a text</SqlMethodComment>
+    <Sql>
+      delete from ad_textinterfaces t
+       where isUsed='N'
+         and exists (select 1 
+                       from ad_module m
+                      where m.ad_module_id = t.ad_module_id
+                        and m.isInDevelopment = 'Y')  
+    </Sql>
+  </SqlMethod>
 </SqlClass>