Ask Your Question
0

Base Which is best when setting a Date column default, the GUI or query? If query, how do I construct it?

asked 2019-01-31 18:24:03 +0100

updated 2019-01-31 18:46:29 +0100

I'm trying to set two Date columns in one table with Default values. When using the Table Design View GUI, I enter the default values I want and save the changes then save the database. When I edit the table and click on the DATE "Field Types" I do not see the values I previously set. If I click back and forth between the two fields, the DEFAULT values change on each click. I have no confidence they are being set to the values I want.

I tried the query: SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_COLUMNS" WHERE "TABLE_SCHEM" = 'PUBLIC'

To try and see what the two column DEFAULT Date values were and I don't see a column that I interpret as to what would be the DEFAULT.

Am I way out in left field? Is this something I shouldn't worry about but just trust the GUI?

If there is a way to set then view what the DEFAULT Date values are with queries, would someone offer suggestion(s) on what query to use, please?

I'm using default HSQLDB.

Thank you in advance!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2019-01-31 20:32:50 +0100

Ratslinger gravatar image

Hello,

Using your query for the schema, the default value is in the column titled COLUMN_DEF.

For information on default values in tables see the following:

tdf#104375

Automatic Date Input Base

Macro for default date equal Today

edit flag offensive delete link more

Comments

@Ratslinger - I guess I wasn't way out in La La Land after all. Thank you for the feedback and the additional reading material. Even though nobody has posted an update in the bug report after the QA team requested it in November of last year, I'd say the problem still exists, FWIW.

For me, (SIGH) I'm not going to let the lack of a Default date for the columns bother me, but move forward with my project update.

I really appreciate the informational links!

Inkblotr gravatar imageInkblotr ( 2019-01-31 22:26:42 +0100 )edit

An item remains open until someone submits a fix, it is confirmed and the item marked as solved. It will also then shoe the LO version where the fix is first applied.

If you read the links (there are more around), even with the open problems defaults can still be set. It is just a bit more difficult.

Ratslinger gravatar imageRatslinger ( 2019-01-31 22:33:35 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-01-31 18:24:03 +0100

Seen: 22 times

Last updated: Jan 31