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

Software: Libreoffice base
Version: (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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.