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
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:
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
: CURRENT_DATE or TODAY default date in Base
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
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
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 the
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 alex.thurg...@gmail.com wrote:
Le 30/08/11 11:18, John Mullen a écrit :
Hi John,
have tried this but although the Status
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
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:
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:ToolsSQL...
ALTER TABLE My Table ALTER COLUMN My Date DATE DEFAULT CURRENT_DATE NOT
NULL
You may leave out NOT NULL or you may unckeck
10 matches
Mail list logo