Software: Libreoffice base
Version: 126.96.36.199 (Debian Wheezy)
Subject: Cannot add auto-increment field as 4th field.
Goal: Add 4th field as unique ID / record counter.
1. Table with 3 fields as primary key.
2. Added 4th field as integer
3. Set 4th field as auto-increment.
4. Saved table which completes without errors or warnings.
5. Opened table and 4th field is not set as auto-increment.
This is very frustrating because I need the 4th field to be
auto-incrementing so that I can set it as the primary key for the
table. This table has evolved to the point where it needs a unique ID
field for performance reasons.
I've tried opening the table up and manually enumerating the 4th field
before turning on the "auto-increment" and it still doesn't save the
field as "auto-increment".
I've been able to do this kind of operation with a large number of
other database software (MS Access, MS SQL, MySQL, etc.) but it's my
first time using Libreoffice. Am I doing something obviously wrong
It seems Libreoffice base only supports the first field in every table
as an auto-increment field. Is this true? And if that's the case do I
need to completely recreate the whole table to add an auto-increment
Is this a bug? Or a feature limitation?
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] Cannot add auto-increment field as 4th field. · David Smith
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