I'm in the process of migrating a PFC-based PB 7.0.3 Enterprise application to PB 9.0.1 Enterprise and have encountered some strange date validation problems.
I have several datawindows which have date and/or datetime datatype columns (plain old edit box style) that will not allow the entry of dates with the day value greater than 30 - ie '11/30/2003', '01/31/2004', etc., unless the entire column is selected/highlighted. If you attempt to change a columns date (retrieved from the database or prefilled either by code in the parent window or set by intial value in the datawindow object) by using the arrow keys to navigate to the day position of the column and then attempt to change '11/29/2003' to '11/30/2003', it does not recognize the 3 key has been depressed and if you're not paying attention while keying the result is '11/09/2003' (assuming that you only entered the day '30'). If I select/highlight the contents of the column (by tabbing off the column and then tabbing back to the column) I am able to enter the date values correctly. All of my datawindows with date columns of this style are behaving this way since being migrated.
The datawindow's column has its Edit properties selected as Style Type 'EditMask' with Mask as 'mm/dd/yyyy' and Type as 'date' or 'datetime'. The application was generated as .pbd files and is running under Windows 2000 SP 4. The application behaves the same running through the IDE or when running the deployed client. If I am previewing while editting/modifying the datawindow object, I am able to enter the date properly.
Any ideas/suggestions appreciated.
I have several datawindows which have date and/or datetime datatype columns (plain old edit box style) that will not allow the entry of dates with the day value greater than 30 - ie '11/30/2003', '01/31/2004', etc., unless the entire column is selected/highlighted. If you attempt to change a columns date (retrieved from the database or prefilled either by code in the parent window or set by intial value in the datawindow object) by using the arrow keys to navigate to the day position of the column and then attempt to change '11/29/2003' to '11/30/2003', it does not recognize the 3 key has been depressed and if you're not paying attention while keying the result is '11/09/2003' (assuming that you only entered the day '30'). If I select/highlight the contents of the column (by tabbing off the column and then tabbing back to the column) I am able to enter the date values correctly. All of my datawindows with date columns of this style are behaving this way since being migrated.
The datawindow's column has its Edit properties selected as Style Type 'EditMask' with Mask as 'mm/dd/yyyy' and Type as 'date' or 'datetime'. The application was generated as .pbd files and is running under Windows 2000 SP 4. The application behaves the same running through the IDE or when running the deployed client. If I am previewing while editting/modifying the datawindow object, I am able to enter the date properly.
Any ideas/suggestions appreciated.