0007680: New Columns cannot be added with EM_XXX prefix

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0007680

Openbravo ERP

00. Application dictionary

public

2009-02-19 13:18

2009-03-18 11:03

Reporter

roklenardic

Assigned To

alostale

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Ubuntu 8.10

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0007680: New Columns cannot be added with EM_XXX prefix

Description

Imagine you add a new column to the M_ProductPrice database table following the guidelines on http://wiki.openbravo.com/wiki/Projects/Modularity/Developers_Guide#Table_and_column [^]

ALTER TABLE m_productprice ADD COLUMN em_howto_calculate_average_price CHARACTER(1) NOT NULL DEFAULT '';

Our custom module is a template in development with the DB Prefix defined as HOWTO.

When trying to enter this new column into the Table and Column for the M_ProductPrice table, I cannot add it with DB COlumn Name = 'EM_HOWTO_Calculate_Average_Price' since I get a red alert 'ERROR: Names must start with its module's DB prefix'.

I thought about saving it as a 'HOWTO_Calculate_Average_Price' hoping that the application will figure the EM_ part out considering this particular new field is part of a custom template. I am able to save then but the compilation fails saying:
...
    [java] 1007 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/Product/Accounting_data.xsql processed
        [java] 1097 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/Product/Price_data.xsql processed
        [java] org.postgresql.util.PSQLException: ERROR: column m_productprice.howto_calculate_average_price does not exist
        [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
...

obviously not finding the specified column since it starts with EM_ as specified in the guidelines.

Steps To Reproduce

Proposed Solution

Is the error in the guidelines or the application?

Additional Information