Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008707Openbravo ERP00. Application dictionarypublic2009-04-22 13:542009-05-10 00:00
nataliaperu 
alostale 
urgentminoralways
closedfixed 
5
2.50 
2.50MP1 
Core
No
0008707: Dates in generated windows, has 8 lenght (by default) instead of 10
When "Columns from DB" are executed and exists columns with "Date" reference, by default, their length is 8 instead of 10 (dd-mm-yyyy).

After compiling the window, if a new date is entered in a date field, only can be entered a date like this: 12-04-20. After focus is in other field, the application shows a date like this: 12-04-2020.
Create a new table in the AD (it must contain a date column)
Use "Create columns from DB".
Generate a window for this table.
Compile the new window.
Restart tomcat.
Create a new record in the new window.
Try to enter a date in a date field.
250MP1
Issue History
2009-04-22 13:54nataliaperuNew Issue
2009-04-22 13:54nataliaperuAssigned To => rafaroda
2009-04-23 12:51psarobeAssigned Torafaroda => alostale
2009-04-23 12:51psarobePrioritynormal => urgent
2009-04-23 12:51psarobeStatusnew => scheduled
2009-04-23 16:04psarobeTag Attached: 250MP1
2009-04-29 11:12alostaleNote Added: 0015904
2009-04-29 11:19alostaleNote Added: 0015905
2009-04-29 11:25hgbotCheckin
2009-04-29 11:25hgbotNote Added: 0015907
2009-04-29 11:25hgbotStatusscheduled => resolved
2009-04-29 11:25hgbotResolutionopen => fixed
2009-04-29 11:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d6f9bbfec55066dd37bd8db63c9c8df4880d1557 [^]
2009-05-09 13:34psarobeRegression testing => No
2009-05-09 13:34psarobeStatusresolved => closed
2009-05-10 00:00anonymoussf_bug_id0 => 2789544

Notes
(0015904)
alostale   
2009-04-29 11:12   
This happens in PostgreSQL but not in Oracle
(0015905)
alostale   
2009-04-29 11:19   
In Oracle the length is assigned to 19 (not 10), the fix will do the same for PostgreSQL
(0015907)
hgbot   
2009-04-29 11:25   
Repository: erp/devel/pi
Changeset: d6f9bbfec55066dd37bd8db63c9c8df4880d1557
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Apr 29 11:24:49 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d6f9bbfec55066dd37bd8db63c9c8df4880d1557 [^]

fixed bug 0008707: Dates in generated windows, has 8 lenght (by default) instead of 10

---
M src-db/database/model/functions/AD_TABLE_IMPORT.xml
---