Thanks Andreas, I had not realised that the Base GUI would not show the changes applied to the underlying database.
Your solution works fine. How do I mark the Topic as SOLVED? Best regards John On 3 September 2011 12:36, Andreas Säger <ville...@t-online.de> wrote: > > 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 > > -- Cheapest mobile tariffs - GUARANTEED <http://www.discoverhow.co.uk/> "I train people to make money" <http://www.makemoney.discoverhow.co.uk/> "Action always beats inaction" - Robert T. Kiyosaki -- 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