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+h...@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.
todhopk...@hillmanncarr.com
--
Unsubscribe instructions: E-mail to users+h...@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
