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

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