Re: [Openbravo-development] onCreateDefault and check constraint for a new column

2010-02-04 Thread Antonio Moreno
Hi all, There is a problem with the execution of onCreateDefault statements for non-mandatory columns in Oracle. The issue was introduced as part of the fix for this issue: https://issues.openbravo.com/view.php?id=11886 Due to the issue 11886 (and other issues related to the same problem) we

Re: [Openbravo-development] onCreateDefault and check constraint for a new column

2010-02-03 Thread Rafa Roda @ Openbravo
Some clues: 1. Please notice that you need to add an Attribute Set Value to any product with an Attribute Set in order to make it fail: update m_product set m_attributesetinstance_id = '100' where name in ('Boots', 'Body') 2. This new column is not mandatory: anyway we want to use

[Openbravo-development] onCreateDefault and check constraint for a new column

2010-02-02 Thread Rafa Roda @ Openbravo
Hi Openbravo developers, I was just trying to add a new column named "ATTRSETVALUETYPE" to the "M_PRODUCT" table with an onCreateDefault value and a check constraint (see patch attached): - - The column is created but neither the onCreateDefault value no