Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.