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.3.1, Ubuntu package 1:3.3.3-1ubuntu2 Is there an error log that I can check out to see why the SQL request failed? Best regards John On 29 August 2011 14:44, Andreas Säger <villeroy@t-online.de> 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: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 Edit>Database>Advanced: "Form checks for required fields". Otherwise you get a form errors about missing data. -- View this message in context: http://nabble.documentfoundation.org/CURRENT-DATE-or-TODAY-default-date-in-Base-tp3292686p3292724.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