0003985: identifier&isselectioncolumn on foreign keys when generating windows.

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0003985

Openbravo ERP

00. Application dictionary

public

2008-06-16 11:16

2008-06-25 16:21

Reporter

galderromo

Assigned To

alostale

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Gentoo 2.6.24

Product Version

2.35MP4

Target Version

Fixed in Version

2.35MP6

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

0003985: identifier&isselectioncolumn on foreign keys when generating windows.

Description

It looks like when generating a window, if there is a foreign key, WAD gets the column matching the lowest sequence and isselectioncolumn='Y' even if this column is not an identifier. Although the application is looking for an identifier.

Steps To Reproduce

Using the standard configuration.
1- Trough the application dictionary go to table: C_BPARTNER.
2- Column: TaxID
3- Get the lowest sequence and mark as isselectioncolumn, make sure it is not an identifier.
4- Compile Bank Statement window (for example)
ERROR:
     [java] 1535 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/BankStatement/Lines_data.xsql processed
     [java] 1726 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java] SELECT FROM C_BPartner WHERE isActive='Y' AND C_BPartner_ID = ?
     [java] Exception:java.sql.SQLException: ORA-00936: missing expression
5- Mark TaxID column as identifier and compile Bank Statement window: NO ERROR
6- Mark TaxID column as no identifier and get a higher sequence and compile Bank Statement window: NO ERROR

Proposed Solution

Additional Information