details: https://code.openbravo.com/erp/stable/2.50/rev/d395842756a9 changeset: 9712:d395842756a9 user: Ioritz Cia <ioritz.cia <at> openbravo.com> date: Fri Oct 21 14:36:51 2011 +0200 summary: Fixes issue 18832: If we change the name of an element value, the description and the Combination of the Account Combination are not saved properly.
details: https://code.openbravo.com/erp/stable/2.50/rev/72796958deef changeset: 9713:72796958deef user: Ioritz Cia <ioritz.cia <at> openbravo.com> date: Thu Oct 27 16:16:42 2011 +0200 summary: Fixes issue 18907: In Balance sheet setup the user can select an accounting scheme that does not match the selected organization. details: https://code.openbravo.com/erp/stable/2.50/rev/17e4b87d5655 changeset: 9714:17e4b87d5655 user: Ioritz Cia <ioritz.cia <at> openbravo.com> date: Thu Oct 27 17:21:55 2011 +0200 summary: Fixes issue 18911: User. Email server username limited to 20 characteristics. diffstat: src-db/database/model/tables/AD_CLIENT.xml | 2 +- src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml | 8 ++++---- src-db/database/sourcedata/AD_COLUMN.xml | 3 ++- src-db/database/sourcedata/AD_VAL_RULE.xml | 11 +++++++++++ 4 files changed, 18 insertions(+), 6 deletions(-) diffs (70 lines): diff -r a7fadd2825a7 -r 17e4b87d5655 src-db/database/model/tables/AD_CLIENT.xml --- a/src-db/database/model/tables/AD_CLIENT.xml Tue Oct 25 17:02:42 2011 +0200 +++ b/src-db/database/model/tables/AD_CLIENT.xml Thu Oct 27 17:21:55 2011 +0200 @@ -49,7 +49,7 @@ <default/> <onCreateDefault/> </column> - <column name="REQUESTUSER" primaryKey="false" required="false" type="NVARCHAR" size="20" autoIncrement="false"> + <column name="REQUESTUSER" primaryKey="false" required="false" type="NVARCHAR" size="40" autoIncrement="false"> <default/> <onCreateDefault/> </column> diff -r a7fadd2825a7 -r 17e4b87d5655 src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml --- a/src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml Tue Oct 25 17:02:42 2011 +0200 +++ b/src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml Thu Oct 27 17:21:55 2011 +0200 @@ -103,11 +103,11 @@ -- Update combination and description fields only if needed to not to trigger a cross tables update UPDATE C_ValidCombination SET Updated=now(), - combination= TO_CHAR((SELECT AD_ORG.NAME FROM AD_ORG WHERE AD_ORG.AD_ORG_ID = C_VALIDCOMBINATION.AD_ORG_ID)) || '-' || :new.VALUE || '-_-_-_', - description= TO_CHAR((SELECT AD_ORG.NAME FROM AD_ORG WHERE AD_ORG.AD_ORG_ID = C_VALIDCOMBINATION.AD_ORG_ID)) || '-' || :new.NAME || '-_-_-_' + combination= TO_CHAR(REPLACE(combination, :old.VALUE, :new.VALUE)), + description= TO_CHAR(REPLACE(description, :old.NAME, :new.NAME)) WHERE (Account_ID=:new.C_ElementValue_ID OR User1_ID=:new.C_ElementValue_ID OR User2_ID=:new.C_ElementValue_ID) - AND (combination <> (TO_CHAR((SELECT AD_ORG.NAME FROM AD_ORG WHERE AD_ORG.AD_ORG_ID = C_VALIDCOMBINATION.AD_ORG_ID)) || '-' || :new.VALUE || '-_-_-_') - OR description <> (TO_CHAR((SELECT AD_ORG.NAME FROM AD_ORG WHERE AD_ORG.AD_ORG_ID = C_VALIDCOMBINATION.AD_ORG_ID)) || '-' || :new.NAME || '-_-_-_')); + AND (combination <> (TO_CHAR(REPLACE(combination, :old.VALUE, :new.VALUE)))) + OR description <> (TO_CHAR(REPLACE(description, :old.NAME, :new.NAME))); UPDATE Fact_Acct SET AcctValue=:new.VALUE,AcctDescription=:new.DESCRIPTION WHERE Account_ID=:new.C_ElementValue_ID; END IF; diff -r a7fadd2825a7 -r 17e4b87d5655 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Tue Oct 25 17:02:42 2011 +0200 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu Oct 27 17:21:55 2011 +0200 @@ -106619,7 +106619,7 @@ <!--6559--> <COLUMNNAME><![CDATA[RequestUser]]></COLUMNNAME> <!--6559--> <AD_TABLE_ID><![CDATA[112]]></AD_TABLE_ID> <!--6559--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> -<!--6559--> <FIELDLENGTH><![CDATA[20]]></FIELDLENGTH> +<!--6559--> <FIELDLENGTH><![CDATA[40]]></FIELDLENGTH> <!--6559--> <ISKEY><![CDATA[N]]></ISKEY> <!--6559--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--6559--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> @@ -253368,6 +253368,7 @@ <!--1000600025--> <COLUMNNAME><![CDATA[C_Acctschema_ID]]></COLUMNNAME> <!--1000600025--> <AD_TABLE_ID><![CDATA[800223]]></AD_TABLE_ID> <!--1000600025--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--1000600025--> <AD_VAL_RULE_ID><![CDATA[FF808181331826EF01331B7415480041]]></AD_VAL_RULE_ID> <!--1000600025--> <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH> <!--1000600025--> <ISKEY><![CDATA[N]]></ISKEY> <!--1000600025--> <ISPARENT><![CDATA[N]]></ISPARENT> diff -r a7fadd2825a7 -r 17e4b87d5655 src-db/database/sourcedata/AD_VAL_RULE.xml --- a/src-db/database/sourcedata/AD_VAL_RULE.xml Tue Oct 25 17:02:42 2011 +0200 +++ b/src-db/database/sourcedata/AD_VAL_RULE.xml Thu Oct 27 17:21:55 2011 +0200 @@ -1773,4 +1773,15 @@ <!--FF8081812F06A183012F07323A2A001C--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--FF8081812F06A183012F07323A2A001C--></AD_VAL_RULE> +<!--FF808181331826EF01331B7415480041--><AD_VAL_RULE> +<!--FF808181331826EF01331B7415480041--> <AD_VAL_RULE_ID><![CDATA[FF808181331826EF01331B7415480041]]></AD_VAL_RULE_ID> +<!--FF808181331826EF01331B7415480041--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--FF808181331826EF01331B7415480041--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--FF808181331826EF01331B7415480041--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--FF808181331826EF01331B7415480041--> <NAME><![CDATA[C_AcctSchema - Schemas matching selected Org.]]></NAME> +<!--FF808181331826EF01331B7415480041--> <TYPE><![CDATA[S]]></TYPE> +<!--FF808181331826EF01331B7415480041--> <CODE><![CDATA[AD_ISORGINCLUDED(@AD_Org_ID@, AD_Org_Id, @AD_Client_ID@) <> -1]]></CODE> +<!--FF808181331826EF01331B7415480041--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--FF808181331826EF01331B7415480041--></AD_VAL_RULE> + </data> ------------------------------------------------------------------------------ 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@Cisco 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
