Ask Your Question

Time display in Base after update to [closed]

asked 2013-07-29 21:59:00 +0200

BruceE gravatar image

updated 2015-11-06 04:47:40 +0200

Alex Kemp gravatar image

Following 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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-06 04:47:59.567759


Are you using the embedded database (HSQLDB v1.8) or a split database arrangement? If split, which database are you using?

oweng gravatar imageoweng ( 2013-07-30 03:29:59 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-08-09 06:19:58 +0200

frofa gravatar image

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.

edit flag offensive delete link more

answered 2013-07-30 22:58:05 +0200

BruceE gravatar image

I am using the embedded database (HSQLDB v1.8). BruceE

edit flag offensive delete link more


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

BruceE gravatar imageBruceE ( 2013-08-01 02:03:14 +0200 )edit

Question Tools



Asked: 2013-07-29 21:59:00 +0200

Seen: 202 times

Last updated: Aug 09 '13