Re: [libreoffice-users] Re: Base Field Defaut Disables Save

MySQL is quite simple once you get started. Makes it much easier with a 
tool like Webmin.
We started extensively with the old Lotus Approach and then migrated to 
PHP/MySQL for general cross platform browser access. I keep looking at 
Base, but it hasn't reached the state of Approach so haven't dived in.
steve

On 4/05/11 12:55 AM, Tod Hopkins wrote:
> 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 users+help@libreoffice.org
> > 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.
> todhopkins@hillmanncarr.com

--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
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