Following 4.1.0.4 upgrade I’ve been having problems with a database with time fields. Originally I had a table with a time field in hh:mm PM/AM format. I also created an input form with a field to enter this time in each new record. Following upgrade original table shows time in hh/mm/ss format. I can change the table field back to hh/mm am/pm format, but when I enter input form to enter new record times they all appear shown 00:00 AM. Also If I go back to the table, the fields are back in the hh/mm/ss format. I am using Windows XP SP3 but same problem occurs with laptop with windows 7.
Are you using the embedded database (HSQLDB v1.8) or a split database arrangement? If split, which database are you using?
The problem is caused by BUG that has been reported HERE and also HERE. It affects only LO version 4.1. Looks like it has been fixed for future releases now.
I am using the embedded database (HSQLDB v1.8). BruceE
After some experimenting with this problem it appears to be caused by form that I use to populate the database. After completing the form, if I do ANYTHING with mouse including saving the prompt the time reverts to 00:00 in the input form. Also on another database WITHOUT the time field the confirmation request to Close Saving Changes, Close Without Saving Changes or Cancel doesn’t appear. What is going on? BruceE