Hi, On Wed, 2011-08-17 at 11:53 -0700, ncreamer wrote:
> Helpful thread - thank you. Any idea why not even the SQL tool will set a > default value for me? I spent lots of time in the Base_Tutorial and created > tables with SQL. The field that follows does NOT have a default value of 1 > and, as this thread confirms, I can't set it in design mode. > > "FieldName" NUMERIC(10) DEFAULT 1, > > All my tables/relationships, etc. execute without fail (after much trial & > error) but when I create entries in this table, I do not get a default value > of 1. Any ideas? > What was the SQL command you used to create the default values in your table? It might be a problem of the initiation query. > Mac OS 10.5.8 > LO 3.4.0 > > Thanks. > > -- > View this message in context: > http://nabble.documentfoundation.org/Base-Field-Defaut-Disables-Save-tp2890141p3262592.html > Sent from the Users mailing list archive at Nabble.com. > -- Jay Lozier [email protected] -- 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
