To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104901 Issue #|104901 Summary|After changing default values in tables the Primarykey | Autoincrement starts at 0 Component|Database access Version|OOo 3.1.1 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|ud
------- Additional comments from [email protected] Tue Sep 8 19:06:44 +0000 2009 ------- After changing default values in tables, the Primarykeyfield with an Autoincrement starts at 0. I used the hsqldb on WinXp. Please open attached database -open "Tabelle1" in design view -set default value "dtNumber" to 1 -set default value "dtOld" to no -save "Tabelle1" and close -open "Tabelle1" by doubleclick -insert a new dataset, and leave the row by using the TAB-key => Error message => klick Ok - leave the row by using the TAB-key => Error message => klick Ok After 6 Times to leave the row by TAB-key and klick OK, the Autoincrement is back to 6 and can work proper. But if you change -set default value "dtOld" to yes, the game will start from beginn. But if there where more datasets (e.g. 500) in the table it is no fun, to get the autoincrement to work again. It could be also, to get wrong data. --------------------------------------------------------------------- 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]
