Apache OpenOffice (AOO) Bugzilla – Issue 55968
Initial AutoValue of Primary Key differs depending upon creation method
Last modified: 2013-02-07 22:33:42 UTC
OOo 2.0 RC2 - Base: 1) Use Wizard to create a table (e.g., Catagory: Business, Assets) and use Set primary key to Use and existing fileld as primary key (e.g., Fieldname: AssetID with Auto value) 2) Open Assets table, add a record, and notice that AssetID for first record is equal to '0' 3) Close Assets table and copy it by selecting Assets object in Tables pane and dropping it on Tables icon in Databse pane 4) Set Table name (e.g., Assets2) and Primary key and Name (e.g., ID) 5) Apply columns except AssetID, to prevent error due to creating of second primary key, and create table 6) Edit Assets2 table, select ID field name, which is Primary Key, and set AutoValue to "yes". 7) Open Assets table, add a record, and notice that AssetID for first record is equal to '1' Note: This is a problem when importing tables with foreign keys: don't know when to set foreign key values starting at '0' or '1'
send further to: requirements