Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionarycriticalalways2021-02-20 14:322021-02-20 14:32
Reporterneil_smithView Statuspublic 
Assigned Toplatform 
PriorityimmediateResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0045931: Create Fields button in Window, tabs and fields-Tab not working (0 fields created)

DescriptionIt is not possible to create fields in a tab anymore using the 'Create Fields' procedure (AD_TAB_IMPORT0)
Steps To ReproduceCreate a window with a tab based on the C_BPARTNER table for example.
Click on button 'Create Fields'
-> 0 Fields created
Proposed SolutionThe problem is in the AD_TAB_IMPORT function.

You added a join on the USER_TAB_COLUMNS in last version and you do a join on the name of the table and name of the column

In the USER_TAB_COLUMN, all the names (tablename and columnname) are uppercased!

When you join on the tablename and columnname, use UPPER() on both.
-> utc.table_name = UPPER(t.tablename) AND utc.column_name = UPPER(c.Columnname)

I can only guess that this change was not tested at all... The only way to make it work would be that the table name and column names would all be in uppercase in the dictionnary (and it is not the case)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2021-02-20 14:32 neil_smith New Issue
2021-02-20 14:32 neil_smith Assigned To => platform
2021-02-20 14:32 neil_smith Modules => Core
2021-02-20 14:32 neil_smith Triggers an Emergency Pack => No

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker