I am working on a contact management database in Libre Office 3.3.1. In it, I
have an Addresses table and an AddrTypes table.
The Address Types table has two fields: AddrTypeID (Primary Key, Integer,
autovalue) and AddrType (VarChar, 25 characters - specifying the type of
address... Home, Work, Mailing, etc.).
The Addresses table has the following fields:
AddrID (Primary Key, Integer, autovalue)
Address (VarChar, 75 characters, entry required)
City (VarChar, 70 characters, entry required)
State (VarChar, 2 characters, default:CA, entry required)
Zip (Integer, 10, entry required, formatted to look like a zip)
AddrTypeID (Foreign Key, Int, entry required, links to same field in AddrTypes)
PersonID (Foreign Key, Int, entry required, links to same field in People table)
Whenever I try to put a default value in Addresses.AddrTypeID, Base won't save
the table... not with the toolbar button, not with menu command, not with
keyboard shortcut. If I close the table, I get the message that the table has
been changed and do I want to save it. I click "Save" and Base returns me to the
table design view, as if I had clicked "Cancel."
If I "Save as..." and give the table a new name, then rename it back to its
original name, Base drops the PersonID field AND the default value for
AddrTypeID. Open the table back up in design view, and PersonID is gone. If I
put it back (and AddrTypeID default value), the table won't save (behavior as in
previous paragraph). However, once I delete AddrTypeID's default value, table
saves, just fine.
I even tried re-creating the table, from scratch, entering everything exactly as
I wanted it, in order, then saving straight to the correct name. No dice.
PersonID was gone when I reopened the table, along with AddrTypeID's default
value. Oddly, the "CA" default value for State has no issues.
Ideas? Solutions? Any help would be appreciated. Thanks in advance!
Fair day and be well,
Unsubscribe instructions: E-mail to firstname.lastname@example.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
- [libreoffice-users] Bug - Base: Default field value not saving or table dropping another field. · Christopher S . Knepper
Impressum (Legal Info)
: 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