To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55968 Issue #:|55968 Summary:|Initial AutoValue of Primary Key differs depending |upon creation method Component:|Database access Version:|OOO 2.0 Beta2 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|dlanderson
------- Additional comments from [EMAIL PROTECTED] Thu Oct 13 20:37:05 -0700 2005 ------- 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' --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]