oblem is solved.
http://nabble.documentfoundation.org/CURRENT-DATE-or-TODAY-default-date-in-Base-td3292686.html#a3306544
Regards from
Tom :)
From: Andreas Säger
To: users@global.libreoffice.org
Sent: Sat, 3 September, 2011 14:32:18
Subject: [libreoffice-users] Re:
DiscoverHow.Co.Uk wrote:
>
>
> Your solution works fine. How do I mark the Topic as SOLVED?
>
Since this is a mailing list, there are hundreds mail copies distributed
already. There is no way to add/update/delete anything that has been posted
already. This is a huge advantage for collaborating
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 wrote:
>
> Alexander Thurgood wrote:
> >
> >
> > The co
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 al
Tractor wrote:
>
> Hi,
>
> When I created my forms about 8 years ago, the OpenOffice Base tutorial
> then recommended the use of the drop down date field. It isn't as nice
> as having a date automatically entered, but it is relatively convenient.
>
> On 08/30/2011 05:55 AM, John Mullen wrote:
Hi,
When I created my forms about 8 years ago, the OpenOffice Base tutorial
then recommended the use of the drop down date field. It isn't as nice
as having a date automatically entered, but it is relatively convenient.
On 08/30/2011 05:55 AM, John Mullen wrote:
Thanks Alex,
at least the dr
I use the database software (command line Tools>SQL...) to set DEFAULT
CURRENT_DATE.
In the Base forms I use to not include the date field when I want the
nothing but the current date/time. When I want a user editable date/time, I
use to add a label like: "Date (default: today)" as a reminder that
Thanks Alex,
at least the dropdown in the form Date field has a "TODAY" option saving the
user a little time
Regards
John
On 30 August 2011 10:31, Alexander Thurgood wrote:
> Le 30/08/11 11:18, John Mullen a écrit :
>
> Hi John,
>
> > have tried this but although the Status window in the Exe
Le 30/08/11 11:18, John Mullen a écrit :
Hi John,
> have tried this but although the Status window in the Execute SQL Statement
> Dialog Box reports "1: Command successfully executed." there has been no
> change to the table.
>
The command Andreas gave you updates the table definition so that
Hi Andreas,
have tried this but although the Status window in the Execute SQL Statement
Dialog Box reports "1: Command successfully executed." there has been no
change to the table.
BTW I am using latest version of LO with Ubuntu 11.04
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3
The Base GUI is too stupid to do that trick. It all depends on the database
you are actually using.
For the embedded HSQLDB type of database that is:
menu:Tools>SQL...
ALTER TABLE "My Table" ALTER COLUMN "My Date" DATE DEFAULT CURRENT_DATE NOT
NULL
You may leave out NOT NULL or you may unckeck
11 matches
Mail list logo
