Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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 <villeroy@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+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




-- 
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+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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.