Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010821Openbravo ERP00. Application dictionarypublic2009-09-30 10:212009-10-23 00:00
Reporterazabaleta 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version2.50MP9Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010821: When creating a new window the application should warn the user that the table has no PK
DescriptionIts known that the system dont compile a window when the table it belongs has no PK. For that reason, when creating a tab from a table that has no PK, the ssystem should show a warning to the user.

Asier
Steps To Reproduce
Proposed SolutionThe system when you select the table in the tab window should check if exists at least one column with the reference ID
Additional Information
TagsNo tags attached.
Relationships
related to defect 0009015 closed alostale WAD should check that the compiling window/tabs must have an indentifier 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-30 10:21azabaletaNew Issue
2009-09-30 10:21azabaletaAssigned To => rafaroda
2009-09-30 11:16rafarodaNote Added: 0020582
2009-09-30 11:16rafarodaStatusnew => feedback
2009-09-30 11:24psarobeNote Added: 0020583
2009-09-30 12:11azabaletaNote Added: 0020587
2009-10-09 17:03psarobeStatusfeedback => scheduled
2009-10-09 17:03psarobeTarget Version => 2.50MP9
2009-10-09 17:03psarobeSteps to Reproduce Updated
2009-10-09 17:03psarobeAssigned Torafaroda => alostale
2009-10-09 17:54alostaleRelationship addedrelated to 0009015
2009-10-16 11:26alostaleNote Added: 0021101
2009-10-16 11:52hgbotCheckin
2009-10-16 11:52hgbotNote Added: 0021103
2009-10-16 11:52hgbotStatusscheduled => resolved
2009-10-16 11:52hgbotResolutionopen => fixed
2009-10-16 11:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/66d9136040ab012c5668cee797129b3a31da44e9 [^]
2009-10-22 11:22plujanStatusresolved => closed
2009-10-23 00:00anonymoussf_bug_id0 => 2884252

Notes
(0020582)
rafaroda   
2009-09-30 11:16   
Steps to reproduce and product version please http://wiki.openbravo.com/wiki/Bug_Reporting_Guidelines [^]
(0020583)
psarobe   
2009-09-30 11:24   
Hi Asier,

Are you talking about defining the PK in the AD (which would be reference ID) or in the DB?

Thanks
(0020587)
azabaleta   
2009-09-30 12:11   
I think it does not matter.

Somehow, the AD has a table with no PK. (can be a user error)
The system allows the user to create a tab based on this table, but then it does not compile it.

Putting a message should be easy.

Thanks
(0021101)
alostale   
2009-10-16 11:26   
I think it is better to solve this issue as a verification done before compiling the windows (as in 0009015) rather than preventing it with constraints/triggers since them could be annoying when edition the info.
(0021103)
hgbot   
2009-10-16 11:52   
Repository: erp/devel/pi
Changeset: 66d9136040ab012c5668cee797129b3a31da44e9
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Oct 16 11:51:58 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/66d9136040ab012c5668cee797129b3a31da44e9 [^]

fixed bug 0010821: When creating a new window the application should warn the user that the table has no PK

---
M src-wad/src/org/openbravo/wad/validation/WADValidationResult.java
M src-wad/src/org/openbravo/wad/validation/WADValidator.java
M src-wad/src/org/openbravo/wad/validation/WADValidator_data.xsql
---