https://bugs.freedesktop.org/show_bug.cgi?id=68533
Alex Thurgood <ipla...@yahoo.co.uk> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |WONTFIX
--- Comment #1 from Alex Thurgood <ipla...@yahoo.co.uk> ---
This is what appears in the SCRIPT file of the ODB file you uploaded (this file
is held within the ODB, which is a zipped container containing other
configuration data and the db data) :
SET DATABASE COLLATION "Latin1_General"
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE "Lisa"("ID" INTEGER NOT NULL PRIMARY KEY,"name"
VARCHAR(100),"Number" CHAR(100),"Times" TIMESTAMP DEFAULT CURRENT_TIMESTAMP)
SET TABLE "Lisa" INDEX'184 0'
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
If you create a new entry, the timestamp will be inserted correctly, at least
on my testing this is the case with LO 4.2 master build for OSX 10.8.4.
However, hsqldb 1.8.0 will not automatically update existing timestamp values :
http://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=2002
to do that you need to write a trigger in Java or Basic. This is not a
LibreOffice problem per se and it will not be addressed in the future, as the
project is switching to Firebird for the embedded db engine.
Setting as WONTFIX.
Alex
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
