Fixes issue 22962: Not possible to create a field based on Fact_Acct.Seqno column.
authorMikel Irurita <mikel.irurita@openbravo.com>
Mon, 04 Feb 2013 10:13:06 +0100
changeset 19552 29ce12396f33
parent 19551 6fb7156c455a
child 19553 6aa13988eec1
Fixes issue 22962: Not possible to create a field based on Fact_Acct.Seqno column.
Default value contains an invalid sql (since 2009)
src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Mon Feb 04 09:18:00 2013 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Mon Feb 04 10:13:06 2013 +0100
@@ -241677,7 +241677,6 @@
 <!--58488161BB727382E040007F01002D6A-->  <AD_TABLE_ID><![CDATA[270]]></AD_TABLE_ID>
 <!--58488161BB727382E040007F01002D6A-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
 <!--58488161BB727382E040007F01002D6A-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
-<!--58488161BB727382E040007F01002D6A-->  <DEFAULTVALUE><![CDATA[@SQL=SELECT COALESCE(MAX(SEQNO),0)+10 AS DefaultValue FROM FACT_ACCT WHERE xxParentColumn=@xxParentColumn@]]></DEFAULTVALUE>
 <!--58488161BB727382E040007F01002D6A-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--58488161BB727382E040007F01002D6A-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--58488161BB727382E040007F01002D6A-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>