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+h...@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