I would not have figured that out. The first thread suggests the preferred
method for setting a default would be at the form level rather than at the
table design level anyway. I will look to see if that can be done now. Makes
sense to me.
I would very much like to use Base, but I'm at the edge of having sufficient
knowledge to make it work. It appears that in order to make Base work for me,
I will have to study MySQL and use it as my backend, with base as a front end.
Cheers,
tod
On May 3, 2011, at 3:13 AM, Alexander Thurgood wrote:
> Le 02/05/11 23:08, Tod Hopkins a écrit :
>
> It appears that the UI default value setting capability available
> through the table editor/designer is not propagated to the underlying
> database by design, see this bug report :
>
> http://openoffice.org/bugzilla/show_bug.cgi?id=108100
>
>
> And it also appears that this will not be fixed any time soon, at least
> not in the OOo code, given the work that would be required to fix it, so
> it is probably even less likely to be done in the LibO code where there
> are no specialist db developers AFAIK.
>
> Currently, the only correct way to set a default value in the underlying
> db is to issue a corresponding CREATE TABLE or ALTER TABLE statement via
> the Tools - SQL menu entry.
>
>
> Alex
>
>
> --
> Unsubscribe instructions: E-mail to [email protected]
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/www/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
>
Tod Hopkins
Hillmann & Carr Inc.
[email protected]
--
Unsubscribe instructions: E-mail to [email protected]
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
