[libreoffice-users] Re: CURRENT_DATE or TODAY default date in Base

Alexander Thurgood wrote:
> The command Andreas gave you updates the table definition so that the
> next time you enter a set of data into the table, whether by editing the
> table view directly or via a form, it should input the current date
> automatically.
>
> If this is what you have already tried, and it is not working, then I
> would surmise that it may possibly be linked to this bug :
>
> https://bugs.freedesktop.org/show_bug.cgi?id=38337
>
>
> for which there is currently no remedy...
>
> Alex
All those bugs and incomplete implementations relate to Base. I was using a
completely different software which is very mature and really free of
obvious bugs. 
When we call Tools>SQL... in a native database, we leave this office suite
and send a command to the underlying database software. This will allways
work correctly as far as we use correct SQL syntax.

What I forgot to mention:
menu:View>Refresh Tables lets Base re-read all table definitions so the
relations and table designs "take notice" of the changes we applied to the
underlying database software. 
Nevertheless, the Base GUI will not show any dynamic default values
CURRENT_DATE, CURRENT_TIME, nor CURRENT_TIMESTAMP simply because these
expressions are no valid dates, times, time stamps. 

Default CURRENT_USER, set in the stupid Base GUI for a VARCHAR field, will
put the literal word 'CURRENT_USER'.
All works well when you leave behind that broken GUI sometimes and default
CURRENT_USER will put the name of the logged-in database user which is the
system administrator 'SA' in all embedded HSQLDB.

--
View this message in context: 
http://nabble.documentfoundation.org/CURRENT-DATE-or-TODAY-default-date-in-Base-tp3292686p3306409.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted