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 <[email protected]> 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: [email protected] > 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: [email protected] 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
