Fixes issue 32906: Cannot process an inventory amount update
authorMark <markmm82@gmail.com>
Wed, 20 Jul 2016 17:22:08 +0200
changeset 30050 ea24d6781214
parent 30049 b7bce66ab192
child 30051 c1dff2b0991a
Fixes issue 32906: Cannot process an inventory amount update

The "name" field length in m_inventory table was increased to 100 to avoid errors when records are created or updated if the user is logged in with Spanish (Spain) language and translations have more than 60 characters.
src-db/database/model/tables/M_INVENTORY.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/model/tables/M_INVENTORY.xml	Thu Jul 21 09:12:30 2016 +0200
+++ b/src-db/database/model/tables/M_INVENTORY.xml	Wed Jul 20 17:22:08 2016 +0200
@@ -33,7 +33,7 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="NAME" primaryKey="false" required="true" type="NVARCHAR" size="60" autoIncrement="false">
+      <column name="NAME" primaryKey="false" required="true" type="NVARCHAR" size="100" autoIncrement="false">
         <default/>
         <onCreateDefault/>
       </column>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Thu Jul 21 09:12:30 2016 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Wed Jul 20 17:22:08 2016 +0200
@@ -61827,7 +61827,7 @@
 <!--3550-->  <COLUMNNAME><![CDATA[Name]]></COLUMNNAME>
 <!--3550-->  <AD_TABLE_ID><![CDATA[321]]></AD_TABLE_ID>
 <!--3550-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
-<!--3550-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--3550-->  <FIELDLENGTH><![CDATA[100]]></FIELDLENGTH>
 <!--3550-->  <DEFAULTVALUE><![CDATA[@#Date@]]></DEFAULTVALUE>
 <!--3550-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--3550-->  <ISPARENT><![CDATA[N]]></ISPARENT>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Thu Jul 21 09:12:30 2016 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Wed Jul 20 17:22:08 2016 +0200
@@ -33292,7 +33292,7 @@
 <!--2687-->  <AD_COLUMN_ID><![CDATA[3550]]></AD_COLUMN_ID>
 <!--2687-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--2687-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--2687-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
+<!--2687-->  <DISPLAYLENGTH><![CDATA[100]]></DISPLAYLENGTH>
 <!--2687-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--2687-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--2687-->  <SORTNO><![CDATA[1]]></SORTNO>